View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Zeros Not Showing

Hi,

Put an apostrophe ' in front of them before you type the number or format as
text.

Mike

"jkjmwilliams" wrote:

How do I force numbers beginning with a zero to show? EX: 05678