Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change Date Format
I'm new to Excel 2007. My problem is that I do not know how to stop Excel
from automatically converting text to a date format. For example, when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains 06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91? "06" does mean June but it should stay as "06". Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change Date Format
How do I stop Excel from automatically changing 06-91 to Jun-91?
You can either precede the input: 06-91 with an apostrophe ('), or pre-format the input cells as text beforehand. .. when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. I don't know/have xl2007, but think the above doesn't happen in xl2003 (my ver) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Ann" wrote: I'm new to Excel 2007. My problem is that I do not know how to stop Excel from automatically converting text to a date format. For example, when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains 06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91? "06" does mean June but it should stay as "06". Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) |