Removing Zeros

  • Thread starter Thread starter ceblaser
  • Start date Start date
C

ceblaser

Is anyone aware of a quick way to remove zeros that are in front of a
number? For example, if I have the following numbers:

0000123
0001234
0012345
0123456

I want them to show up as:

123
1234
12345
123456

However, if there is a number with a zero in it I do not want to take
it out. For example, if I have

001203

I want it to show up as 1203 and not 123.

Thanks so much!!!
 
Copy an empty cell.
Select the range with entries having leading zoeroes.
Activate Edit|Paste Special|Add.
 
Hi ceblaser!

Format the cells:

Format > Cells > Number
0 decimal places

At present you appear to have a custom format 0000000

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
At present you appear to have a custom format 0000000

Or text, in which case he will need Aladin's method. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :-)
----------------------------------------------------------------------------



Norman Harker said:
Hi ceblaser!

Format the cells:

Format > Cells > Number
0 decimal places

At present you appear to have a custom format 0000000

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Back
Top