View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Zeros Not Showing

Custom format as 00000
or format as text before you type in the number,
or precede the number with an apostrophe.

The latter two options will leave you with text, rather than a number, so
further calculations may well be affected.
--
David Biddulph

"jkjmwilliams" wrote in message
...
How do I force numbers beginning with a zero to show? EX: 05678