View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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