Free AdviceGet Free Advice
Home | Get advice | Give advice | Topics | Columnists | - !START HERE! -
Make Suggestions | Sitemap

Get Advice


Search Questions

Ask A Question

Browse Advice Columnists

Search Advice Columnists

Chat Room

Give Advice

View Questions
Search Questions
Advice Topics

Login

Username:
Password:
Remember me
Register for free!
Lost Password?

Want to give Advice?

Sign Up Now
(It's FREE!)

Miscellaneous

Shirts and Stuff
Page Backgrounds
Make Suggestions
Site News
Link To Us
About Us
Terms of Service
Help/FAQ
Sitemap
Contact Us

Excel - Deleting "leading" 0's


Question Posted Wednesday March 19 2008, 1:19 am

Is there any way to stop Microsoft Excel 2003 from deleting the "LEADING" 0's??

For example if i were to put in 0123

It deletes the 0.

Is there anyway to stop this? (WITHOUT HACKS etc.)

Thanks so much for all your help to everyone!!!

Kronix

[ Answer this question ]
Want to answer more questions in the Technology category?
Maybe give some free advice about: Computers?

theymos answered Wednesday March 19 2008, 11:26 am:
Select the cells you want affected then go to format, cells. Go to the "numbers" tab.

Choose "text" to keep whatever formatting and 0s you have. You will be unable to perform calculations on those cells, though. Choose "special" and then set the formatting template to whatever you want to keep the ability to perform calculations.

[ theymos's advice column | Ask theymos A Question ]

More Questions:

<<< Previous Question: hoodie
Next Question >>> boyfriends

Recent popular questions:
Want to give advice?

Click here to start your own advice column!

What happened here with my gamer friends?

All content on this page posted by members of advicenators.com is the responsibility those individual members. Other content © 2003-2014 advicenators.com. We do not promise accuracy, completeness, or usefulness of any advice and are not responsible for content.

Attention: NOTHING on this site may be reproduced in any fashion whatsoever without explicit consent (in writing) of the owner of said material, unless otherwise stated on the page where the content originated. Search engines are free to index and cache our content.
Users who post their account names or personal information in their questions have no expectation of privacy beyond that point for anything they disclose. Questions are otherwise considered anonymous to the general public.
[Valid RSS] eXTReMe Tracker