I have a number formatted as text that I need to take a part of and place in
a new cell. For example I want to take -01250 and place 0125 in a new cell.
I tried mid, left, right but I lose the leading zero. Any help would be much
appreciated.
Thanks. (excel 2003)
--
JH