text format question

J

JH

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)
 
J

Jacob Skaria

Format cell B1 to general and enter this formula

A = -01250

=MID(A1,2,100)

If this post helps click Yes
 
D

Dave Peterson

=MID(A1,2,99)
worked ok for me.


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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to add decimal to beginning of imported number 2
add decimal to beginning of number 1
REPLACE command drops leading zeros 4
Format number as text on import 3
Custom Number Format for text 8
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Leading Zero Dropped in Text Cell 3
Remove preceding zeroes? 1

Top