I am trying to replace a text number 1234.50- to a number -1234.50 please help.
M marieta Oct 31, 2004 #1 I am trying to replace a text number 1234.50- to a number -1234.50 please help.
B Brian Oct 31, 2004 #2 marieta said: I am trying to replace a text number 1234.50- to a number -1234.50 please Click to expand... help. -1 * Val(Left(SomeText, Len(SomeText)-1))
marieta said: I am trying to replace a text number 1234.50- to a number -1234.50 please Click to expand... help. -1 * Val(Left(SomeText, Len(SomeText)-1))
