View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I change the format to allow a zero as a first digit?

One way is to enter the number as a TEXT entry. To do that precede the entry
with an apostrophe like this: '012345. The apostrophe will not be visible in
the cell.

--
Biff
Microsoft Excel MVP


"MongoTom" wrote in message
...
When I input an ID number, they all start with a zero. Excell
automatically
removes it. How do I turn off this function?