Change negative sign to trail amount

[JazzyLee]

I have tried every trick I can come up with to change negative amounts on my spreadsheet to place the sign at the end of a number instead of at the beginning. Is there a way to do this using VB codes? I am working with Excel 2000. I was able to go from: -555.66 to 555.55)

Don't know why I am getting a parenthesis at the end of my number and I can't figure out what I am doing wrong. HELP!!!!

 

[macropod]

Hi,

You could try something based on:
If Selection.Value < 0 Then Selection.Value = Abs(Selection.Value) & "-"
Note: Doing this converts the value to text.

If you merely want to represent -ve values with the '-' after the value, try a custom number format like:
#,##0.00;[Red]#,##0.00-
with/without the '[Red]'.

Cheers

 

[JazzyLee]

Thanks Macropod! Your second option worked wonderfully.