How to remove 0's in front of numbers?

  • Thread starter Thread starter Kipurr
  • Start date Start date
K

Kipurr

I have a column of numbers, as below. How can I remove the 0 in front?

035000
035002
035006
035009
 
Format as general or as number without any decimals. If they still look the
same they must be text or have invisible characters.



--


Regards,


Peo Sjoblom
 
After specifying the format as number you have to activate them so you would
have to activate them as reentries.

One way would be to select an empty cell then select the cells you need to convert,
then right click, then Paste Special, then Add

That is better than multiplying by 1 as it will not damage empty cells.

For more information see
Number Conversions
http://www.mvps.org/dmcritchie/excel/numconv.htm
 
Hi,

You can also try Text to column - Fixed width.
To delete the Zeros from entire row.

Regards,
 

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 do I remove the apostrophe(') in front of zeros 3
In excel how do i get from this 44345678912 to this 0345678912 us. 2
How add a digit to front of number in each cell in excexl column 1
Access Tidy up phone numbers 0
How to arrange number? 9
Automatic Removal of 0's in front of data 1
How to avoid value losing zero in front of digits?? 1
Negative Numbers 8

Back
Top