Format the cell as Text prior to entering the data, or precede
the data with an apostrophe. The apostrophe will not show in the
cell but will in the formula bar.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
