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?
|