0

I have a column imported from something else where money values are expressed as 123.00DB

I need to convert them to something more useful, which needs to be numeric, eg -123.00

I want to do this with a cell formula rather than GUI point and click.

There are two steps... convert the trailing DB to leading -, then make the cell numeric.

Is this possible?

Improve this question
3
  • Something like: =--LEFT(A1,LEN(A1)-2) maybe? Commented Jul 28, 2022 at 18:59
  • Unfortunately that only gets rid of the DB - doesn't make it negative Commented Jan 23, 2023 at 7:43
  • Remove one of the - from the formula Commented Jan 24, 2023 at 15:59
Related questions
0
Replacing Text in excel fields
0
Excel Find & Replace Tool
5
How to find and replace part of a cell with formatted text
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.