| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format question
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text format question
Format cell B1 to general and enter this formula
A = -01250 =MID(A1,2,100) If this post helps click Yes --------------- Jacob Skaria "JH" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text format question
=MID(A1,2,99)
worked ok for me. JH wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Converting a date to text..Format question | Excel Discussion (Misc queries) | |||
| Date to text format question | Excel Discussion (Misc queries) | |||
| Text import format question | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
