(I hate those programmers that make programs automatically do what they THINK you want it to do)
2007-04-13 02:22:14 · 6 answers · asked by Captain K 2 in Computers & Internet ➔ Software
Thanks, all sorted now.
2007-04-13 02:27:19 · update #1
Go to format cell - on the number tab select custom, then under the word "type" put in 000000 - this will keep the data as a number (rather than text) but will allow the lead zeros.
2007-04-13 02:28:39 · answer #1 · answered by RJ_Moneyman 1 · 3⤊ 0⤋
Either type an apostrophy ( ' ) in front of the number, which converts it to a "text", or format the cell to be a number that has as many digits as you need (Do a Custom format of "000000").
2007-04-13 02:26:08 · answer #2 · answered by dewcoons 7 · 1⤊ 0⤋
You need to format the cell to allow leading zeros. To do this, you can click on format, select cells, then text.
2007-04-13 02:24:51 · answer #3 · answered by Beanbag 5 · 0⤊ 1⤋
Right click on the cell and click format cells and then make it text.
2007-04-13 02:24:24 · answer #4 · answered by EaterOfTartanColouredSmarties 4 · 2⤊ 1⤋
Right click on the cell and in format click "text" it will then leave it alone.
2007-04-13 02:24:38 · answer #5 · answered by leedsmikey 6 · 1⤊ 1⤋
change the cell format to text from number,then you can be sucessful.Good luck.
2007-04-13 02:26:44 · answer #6 · answered by shravanjps 3 · 0⤊ 1⤋