View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default Automatic Removal of 0's in front of data

Hello there,

I need to input some data into excel, but whenever I type in for example,
00000010, excel will automatically remove all the 0's in front of the 10.
However, I actually need to display those 0's, is there any way of changing
the settings not to remove them? I've searched throughout the toolbars and
haven't had any luck changing the settings, hopefully someone out there may
know the answer!

Thank you for your time and advice,

James