Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel - Show Zero At Beginning of Number?
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!
Will typing ' not affect a V-lookup though? Because the first character in the cell will not actually be a zero.
3 Answers
- Anonymous1 decade agoFavorite Answer
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.
- richardLv 44 years ago
1
Source(s): Whois Number Check http://reversephonenumberlookup.enle.info/?Zss7 - 1 decade ago
yes it's a simple type first ' (near shift key) then u input the value in a cell.
ok
