Im having trouble with a spreadsheet I have. It has all kinds of information on it, but when I enter digit values starting with the number "0" it erases the "0" and only keeps the next number!!! Does anyone know why?
This is normal. However, if you need to have a leading zero, there are a few options. If you don't need to do a calculation on the number, for example, it's an account number, then you can simply place a single quote at the beginning of the number. If you do need to perform calculations on the number, then read the following article from Microsoft. http://support.microsoft.com/kb/81518
Thanks alot, the "'" helps out, but a little green check comes out in the upper-left corner. Its not a big deal, but it gets the job done!!!! Thanks again.........
