E Elton Jones Dec 18, 2007 #1 How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet?
How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet?
D Dave F Dec 18, 2007 #2 How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet? Click to expand... Format the cell as text.
How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet? Click to expand... Format the cell as text.
D David Biddulph Dec 18, 2007 #3 Format as text before you enter the data, or Precede the data with an apostrophe to force it to be treated as text, or Format as 000000 if you want to show 6 digits including leading zeroes.
Format as text before you enter the data, or Precede the data with an apostrophe to force it to be treated as text, or Format as 000000 if you want to show 6 digits including leading zeroes.
M Marcelo Dec 18, 2007 #4 format the cell as text hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Elton Jones" escreveu:
format the cell as text hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Elton Jones" escreveu:
