Thread: How do I format a field in Excel to allow for leading zeros?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default How do I format a field in Excel to allow for leading zeros?
Use a number format like 0000, with one zero per digit. For example, a zip
code requires a number format of 00000 or 00000-0000.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"debbie" wrote in message
...
I am creating an Excel Document that has certain values that must have
leading zeros. Does anyone know how to allow leading zeros in Excel?


Reply With QuoteReply With Quote