Quick macro help

[MOB]

A cell contains 12345.56- for example

I want a quick macro that will move the "-" to the front, ie show a proper number -12345.56

How do I do this?

If the cell contains a proper number already eg 123.45 then it should do nothing.

TIA

 

[Dan Waterloo]

Hi MOB,

Here is an extract from the Excel Help file:

Convert numbers stored as text to numbers

Note  Some accounting programs display negative values with the negative sign (–) to the right of the value. To convert the text strings to values, you must return all of the characters of the text string except the rightmost character (the negation sign), and then multiply the result by –1. For example, if the value in cell A2 is "156–" the following formula converts the text to the value –156.

Data Formula 
156- =LEFT(A2,LEN(A2)-1)*-1

You would use this basic idea in your macro.

 

[Dan Waterloo]

Here it is in a more readable format:

Convert numbers stored as text to numbers

Note Some accounting programs display negative values with the negative sign (–) to the right of the value. To convert the text strings to values, you must return all of the characters of the text string except the rightmost character (the negation sign), and then multiply the result by –1. For example, if the value in cell A2 is "156–" the following formula converts the text to the value –156.

Data Formula
156- =LEFT(A2,LEN(A2)-1)*-1