M
montana hogs
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.
automatically turns to Sept.2. Please Help. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
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
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
D
Domenic
Precede your entry with a single quote...
'09-02
....or format your cell as 'Text'.
Hope this helps!
'09-02
....or format your cell as 'Text'.
Hope this helps!
J
John Moore
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.
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.