Since you asked to convert "100-" to -100 via formula,
try this

With numeric text in A1
B1: =SIGN(--(RIGHT(L3,1)&1))*SUBSTITUTE(L3,"-","")

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"How to convert from 100- to -100"
m wrote in message
...
I have a spread sheet that instead of showing negaive 100 as -100, it
shows
negative 100 as 100-, is there any way to convert 100- to -100 by
formular?
Thanks.