View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default I want to display numbers with zeros in front of them, eg 005

Hi,
I have a friend who wishes to display zeros in front of other numbers and
the Excel program keeps disappearing them. I tried to modify the
Tools/Options/View/Zero Values but whether this box is checked or not doesn't
seem to make any difference.
Any ideas would be greatly appreciated.
Tom