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?
|