Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I keep the zeros in front of numbers when i split a cell
I am splitting a cell in the cell is dix00001
I need to split it from the first three letters, and when I do I get dix in one cell and a 1 in the second cell and I need 00001 in the xecond cell. I have tried formatting the column to text and general. Help!!! |
#2
|
|||
|
|||
Either format it as 00000
or get it with =TEXT(RIGHT(A1,5),"00000") -- HTH Bob Phillips "tom" wrote in message ... I am splitting a cell in the cell is dix00001 I need to split it from the first three letters, and when I do I get dix in one cell and a 1 in the second cell and I need 00001 in the xecond cell. I have tried formatting the column to text and general. Help!!! |
#3
|
|||
|
|||
If you split using datatext to columns you can set text format in step 3
under column data format Regards, Peo Sjoblom "tom" wrote in message ... I am splitting a cell in the cell is dix00001 I need to split it from the first three letters, and when I do I get dix in one cell and a 1 in the second cell and I need 00001 in the xecond cell. I have tried formatting the column to text and general. Help!!! |
#4
|
|||
|
|||
Hi,
You can also achieve this through the format cells option in the format menu. Select thr cell and in custom number formats, go to Generel and replace it with "0000"General Regards, Ashish Mathur "tom" wrote: I am splitting a cell in the cell is dix00001 I need to split it from the first three letters, and when I do I get dix in one cell and a 1 in the second cell and I need 00001 in the xecond cell. I have tried formatting the column to text and general. Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting leading zeros in front of number | Excel Discussion (Misc queries) | |||
Social Security Numbers & Leading Zeros | Excel Discussion (Misc queries) | |||
how do I insert an ' in front of many rows of numbers? | Excel Discussion (Misc queries) | |||
Averaging noncontiguous numbers ignoring zeros? | Excel Worksheet Functions | |||
How do I get zeros to stay in front of a # when using the concate. | Excel Worksheet Functions |