How do i prevent the 000's in the beginning of an entry from d
Thanks joe, i'll give it a try
"joeu2004" wrote:
On Feb 8, 5:32 pm, bobby02169
wrote:
I am trying to enter a combination of numbers and letters in a cell and if it
starts with a 0 (zero) when I hit enter to move to another cell all the 0's
at the beginning drop off
EX: 0019301C76F5 becomes 19301C76F5
I think the best way is to enter the data beginning with an apostrophe
('). That tells Excel to treat the data as text. Alternatively, you
could format the cell as Text. But that must be done before you enter
the data.
|