Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-22-2012, 11:16 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline how to enter what i want in cell Windows 7 32bit how to enter what i want in cell Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Excel is a spreadsheet and is designed to work with numbers. Its built-in behaviour to interpret your entry this way is something we all just have to live with. To retain the leading zero, you can either format the cell as text before entering the number, or you can preceed the number with an apostrophe, eg '050

If you don't want to see the green triangle warning that the number is formatted as text then you can disable it in the options. I prefer to keep the warning because some worksheet functions will ignore the data (because they are designed to ignore text).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I delete the content of a cell in column if the cell value is more than 1000? Learner7 Excel 2 06-27-2011 05:44 AM
how to enter what i want in cell Enter + Alt + Enter is not working inside the text box! why???? Jamal NUMAN Word 3 04-17-2011 05:35 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft