Thread: How do I prevent Excel from changing numbers into dates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Aussie Bob C Aussie Bob C is offline
external usenet poster
  
Posts: 24
Default 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?
Reply With QuoteReply With Quote