trying to enter a number that starts with a zero, and would like the zero to stay. ie 0678
G George Feb 15, 2007 #1 trying to enter a number that starts with a zero, and would like the zero to stay. ie 0678
G Gary''s Student Feb 15, 2007 #2 Two ways: 1. precede your entry with an apostrophe (single quote) 2. Format > Cells... > Number > Custom 0000 You can apply the second method to data already entered.
Two ways: 1. precede your entry with an apostrophe (single quote) 2. Format > Cells... > Number > Custom 0000 You can apply the second method to data already entered.
