View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default entering data using - between numbers without converting to date

Try this:

Format those cells to be text, not numbers:

<Format<Cells<Number tab
Category: Text

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Heather" wrote:

I am trying to enter data into a cell using - between numbers for example
1-30-4400, excel is converting this number into a date, I can't change the
way I enter this data, how can I make excel stop converting this?