Replace an endng "-" on a string field to a leading "-" so I can convert to a fixed decima

[knamc_com]

I have some data values coming over from a text file as :

805.99-

.78-

120.89-

I need to be able to convert/replace the ending "-" to a Leading so it will convert to a fixed decimal value.

They need to be:

-805.99

-.78

-120.89

I have tries several expressions, but no luck......could be late in the day on a Friday, lol

[alexnajm · Accepted solution]

IIF(EndsWith([Value], "-"), ToNumber("-"+ReplaceChar([Value],"-","")), ToNumber([Value])) should work