Off-topic Talk Where overpaid, underworked S2000 owners waste the worst part of their days before the drive home. This forum is for general chit chat and discussions not covered by the other off-topic forums.

Microsoft Excel Help!

Thread Tools
 
Old Nov 9, 2004 | 04:07 PM
  #1  
JasonX82's Avatar
Thread Starter
Registered User
 
Joined: Sep 2001
Posts: 1,143
Likes: 0
From: Garden Grove, CA
Default Microsoft Excel Help!

How do I add Zero's like 000513232. It keeps removing the zeros and it becomes 513232.. Stupid Excel trying to be to smart...
Reply
Old Nov 9, 2004 | 04:10 PM
  #2  
PeaceLove&S2K's Avatar
20 Year Member
 
Joined: Jul 2002
Posts: 19,257
Likes: 19
From: San Diego, CA
Default

Are you going to perform calculations on the number? If not, just enter a apotrophe (single quote, really) in front of the number.
I.e.,
'000513232

Otherwise... try looking into cell formatting...
Reply
Old Nov 9, 2004 | 04:10 PM
  #3  
happs22's Avatar
Registered User
 
Joined: Dec 2003
Posts: 1,361
Likes: 0
From: Long Island/C'ville, VA
Default

Format cells and use "Text" in the Number Tab.
Reply
Old Nov 9, 2004 | 04:43 PM
  #4  
NikePenguin's Avatar
Registered User
 
Joined: Jun 2004
Posts: 38,617
Likes: 1
Default

This one I do know... go to Format/Custom... select the Number tab then select Custom in the Category box... find 0 under type (scrolling window)... then add the number of 0's you want in the entry window under Type.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
joefish1298
Aus & NZ Off Topic
5
Jul 5, 2010 02:30 PM
The Raptor
The Corner
16
Mar 1, 2005 09:50 PM




All times are GMT -8. The time now is 12:44 PM.