View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default How to remove 0's in front of numbers?

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

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

035000
035002
035006
035009