Formatting Excel Worksheet

[KI]

Please help.
I have a spreadsheet which has various negative numbers entered as follows:
e.g. 5.25-
0.32-
1,502.33- etc etc
Is there any way to format it or a formula which will change the above
numbers so that it is a negtive number
e.g. -5.25,
-0.32, -
1,502.33 etc etc
I have tried all the usual ways to format it but the numbers still remain as
5.25- etc etc

 

[Don Guillett]

this should do it
Sub fixneg()
For Each c In Selection
If Right(c, 1) = "-" Then c.Value = "-" & Left(c, Len(c) - 1)
Next c
End Sub

 

[Duke Carey]

if your number is in A1, then use this formula in B1

=IF(RIGHT(TRIM(A1),1)="-",-LEFT(A1,LEN(TRIM(A1))-1),A1)

 

[KI]

Thanks for your help.
Worked a treat.

if your number is in A1, then use this formula in B1

=IF(RIGHT(TRIM(A1),1)="-",-LEFT(A1,LEN(TRIM(A1))-1),A1)

 

[KI]

Thank you.

this should do it
Sub fixneg()
For Each c In Selection
If Right(c, 1) = "-" Then c.Value = "-" & Left(c, Len(c) - 1)
Next c
End Sub

 

[Don Guillett]

glad to help