Minus signs at end of cell

[jnaylor]

I have a sheet imported from a mainframe which shows minus signs at the end of the cell instead of the beginning in each cell where the value is minus.
How can I correct this

 

[Ivan F Moala]

On 2002-04-26 03:58, jnaylor wrote:
I have a sheet imported from a mainframe which shows minus signs at the end of the cell instead of the beginning in each cell where the value is minus.
How can I correct this

Rather then recreating the wheel have a look
@ Aarons site....Look here for the file.


http://www.xl-logic.com/xl_files/vba/dash_masher.zip

 

[Jay Petrulis]

Hi,

Didn't download the file from Aaron's site (which is nice), so apologies if this is the same.

Select your range (or modify the routine to find the range) and run this:

Sub test()
Dim c As Range
For Each c In Selection
If Not c.HasFormula And IsNumeric(c) Then c = CDbl(c)
Next c
End Sub

 

[Mark W.]

=IF(RIGHT(A1)="-",-LEFT(A1,LEN(A1)-1),A1)
This message was edited by Mark W. on 2002-04-26 06:51