| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete leading zeros
Could someone please help me. I have forgotten how to delete the zeros
infront of numbers. I havea column of numbers. ie: 0015L 000043 I want to delete all the zeros on the left of the number. Thanks, Joe |
|
#2
|
|||
|
|||
|
See my reply under "Serial Number List". Use Data/Text to columns. Wizard is
fairly explicit. Roger "lunker55" wrote: Could someone please help me. I have forgotten how to delete the zeros infront of numbers. I havea column of numbers. ie: 0015L 000043 I want to delete all the zeros on the left of the number. Thanks, Joe |
|
#3
|
|||
|
|||
|
Copy an empty cell, Select the range of numbers you have, and Paste
Special-Add -- Regards, Dave <!-- "lunker55" wrote: Could someone please help me. I have forgotten how to delete the zeros infront of numbers. I havea column of numbers. ie: 0015L 000043 I want to delete all the zeros on the left of the number. Thanks, Joe |
|
#4
|
|||
|
|||
|
Roger,
That won't work because I have a different number of zeros in each cell. Joe "RogerN" wrote in message ... See my reply under "Serial Number List". Use Data/Text to columns. Wizard is fairly explicit. Roger "lunker55" wrote: Could someone please help me. I have forgotten how to delete the zeros infront of numbers. I havea column of numbers. ie: 0015L 000043 I want to delete all the zeros on the left of the number. Thanks, Joe |
|
#5
|
|||
|
|||
|
Dave
I would have suggested the formula =value() in next available column, as Excel would then strip the leading zeros but I do like your solution . Very neat, thanks. Roger "David Billigmeier" wrote: Copy an empty cell, Select the range of numbers you have, and Paste Special-Add -- Regards, Dave <!-- "lunker55" wrote: Could someone please help me. I have forgotten how to delete the zeros infront of numbers. I havea column of numbers. ie: 0015L 000043 I want to delete all the zeros on the left of the number. Thanks, Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
