Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Sunday 10.8.2025 / 02:21
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - software discussion > help with microsoft excel - deleting my "0" number at start
Show topics
 
Forums
Forums
HELP with Microsoft Excel - Deleting my "0" Number at start
  Jump to:
 
Posted Message
acorrea4
Member
_ 		8. February 2008 @ 11:08 _ Link to this message    Send private message to this user   
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?
[ + quote]
silk42
Senior Member
_ 		8. February 2008 @ 12:57 _ Link to this message    Send private message to this user   
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
[ + quote]
acorrea4
Member
_ 		8. February 2008 @ 13:22 _ Link to this message    Send private message to this user   
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.........
[ + quote]
afterdawn.com > forums > software, operating systems and more > windows - software discussion > help with microsoft excel - deleting my "0" number at start
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2025 by AfterDawn Ltd.

  IDG TechNetwork