Can anyone please tell me how to set Excel to show the Zero at the beginning of a number? I need a certain number of digits in each field but some of the numbers start with zero - I need the zero's to show also as I am doing a V-lookup.
Thanks!
2006-11-23 19:42:43 · 2 answers · asked by Feta Smurf 5 in Computers & Internet ➔ Software
Will typing ' not affect a V-lookup though? Because the first character in the cell will not actually be a zero.
2006-11-23 19:56:34 · update #1
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).
However, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.
2006-11-23 20:30:58 · answer #1 · answered by Anonymous · 0⤊ 0⤋
1
2017-01-22 11:49:46 · answer #2 · answered by ? 4 · 0⤊ 0⤋
yes it's a simple type first ' (near shift key) then u input the value in a cell.
ok
2006-11-23 19:52:21 · answer #3 · answered by KUMAR 3 · 1⤊ 1⤋