How do I prevent Excel from changing numbers into dates?
 

When I type in a number (5-10) for example, it either changes it to a date or
takes of the 0. I want it to show up the exact same way I type it. How can I
do that?

How do I prevent Excel from changing numbers into dates?
 

Format the cell or cells as text
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.


"Slacker" wrote:

When I type in a number (5-10) for example, it either changes it to a date or
takes of the 0. I want it to show up the exact same way I type it. How can I
do that?

How do I prevent Excel from changing numbers into dates?
 

Or prefix your entry with an apostrophe:

'5-10

Slacker wrote:

When I type in a number (5-10) for example, it either changes it to a date or
takes of the 0. I want it to show up the exact same way I type it. How can I
do that?

--

Dave Peterson

You must have formatted the cell in Date format.
Please follow following steps
1.Select the cellRight clickFormat cells
2.From the number tab,select number from the category list
3.Click OK
Now it should work

Have a nice time


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com