Enter an apostrophe before entering the data, the apostrophe does not print
or show up but tells excel that the contents is text. ie '012345 will show
in the cell as 012345 with a green triangle in the corner with a message tht
the cell is formatted as text or preceeded by an apostrophe.

--
Saruman
---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"T.Reisz" wrote in message
...
After reformatting an entire column to carry numbers with leading zeros as
text (employee data), empty cells will revert to scientific notation when
new
data is input. How can I make text the default for all new data in a
column?