numbers to dates
 

New excel user. I am trying to type a part #09-02 in a cell. When I enter It
automatically turns to Sept.2. Please Help. Thanks.

montana hogs, put a ' in front of the number, it want show up, or format the
cell as text before you enter the number
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"montana hogs" wrote in message
...
New excel user. I am trying to type a part #09-02 in a cell. When I enter
It
automatically turns to Sept.2. Please Help. Thanks.

Precede your entry with a single quote...

'09-02

....or format your cell as 'Text'.

Hope this helps!

In article ,
montana hogs wrote:

New excel user. I am trying to type a part #09-02 in a cell. When I enter It
automatically turns to Sept.2. Please Help. Thanks.

Excel will always recognise the dash in the middle of your number as being
part of a date, the easiest way to avoid the number changing to a date is to
put an apostrophe in front of your number ,,,,, '09-02, this will keep it as
a number, not sure this will help you though if you are going to be using
lookups or sumifs on the data.

"montana hogs" wrote:

New excel user. I am trying to type a part #09-02 in a cell. When I enter It
automatically turns to Sept.2. Please Help. Thanks.