Thread: entering data using - between numbers without converting to date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default entering data using - between numbers without converting to date
Either put a ' before the first entry or format the cells as text.

"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?
Reply With QuoteReply With Quote