| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop excel automatically changing my date to 2005?
How can I stop excel from changing a date that I type (i.e 2007) back to
2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#2
|
|||
|
|||
|
Enter the full date, inclusive of the year,
e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr Then format the cell to display the way you want (Format Cells Date Choose a type) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "zoemcb" wrote in message ... How can I stop excel from changing a date that I type (i.e 2007) back to 2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#3
|
|||
|
|||
|
I was typing including the year in the date I typed - 2007, but as soon as I
move on to another cell, the first cell changes from 2007 to 2005. Thanks anyway. "Max" wrote: Enter the full date, inclusive of the year, e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr Then format the cell to display the way you want (Format Cells Date Choose a type) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "zoemcb" wrote in message ... How can I stop excel from changing a date that I type (i.e 2007) back to 2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#4
|
|||
|
|||
|
You sure you are typing as Bernie suggests and it turns to 2005?
i.e. 2/23/2007 or 23/2/2007 If a cell is formatted as date and you enter just 2007 you will get June 29,1905 Gord Dibben Excel MVP On Fri, 29 Apr 2005 08:26:05 -0700, zoemcb wrote: I was typing including the year in the date I typed - 2007, but as soon as I move on to another cell, the first cell changes from 2007 to 2005. Thanks anyway. "Max" wrote: Enter the full date, inclusive of the year, e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr Then format the cell to display the way you want (Format Cells Date Choose a type) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "zoemcb" wrote in message ... How can I stop excel from changing a date that I type (i.e 2007) back to 2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#5
|
|||
|
|||
|
This is how I type it: 4/29/07 then it turns to 4/29/05. Am I not able to
type it as a two digit year as usual? "Gord Dibben" wrote: You sure you are typing as Bernie suggests and it turns to 2005? i.e. 2/23/2007 or 23/2/2007 If a cell is formatted as date and you enter just 2007 you will get June 29,1905 Gord Dibben Excel MVP On Fri, 29 Apr 2005 08:26:05 -0700, zoemcb wrote: I was typing including the year in the date I typed - 2007, but as soon as I move on to another cell, the first cell changes from 2007 to 2005. Thanks anyway. "Max" wrote: Enter the full date, inclusive of the year, e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr Then format the cell to display the way you want (Format Cells Date Choose a type) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "zoemcb" wrote in message ... How can I stop excel from changing a date that I type (i.e 2007) back to 2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#6
|
|||
|
|||
|
Sorry about that Max. Don't know where I got Bernie from.
Gord zoemcb 4/29/07 should work. Can't say what the problem is. ToolsAutoCorrect Options? Anyitem there that may cause it? Does it happen on only one workbook/worksheet or all? If just one, could be some code behind a sheet or thisworkbook. How about Windows Regional Settings. Anything there that could cause this phenomenon? Gord On Fri, 29 Apr 2005 11:50:06 -0700, zoemcb wrote: This is how I type it: 4/29/07 then it turns to 4/29/05. Am I not able to type it as a two digit year as usual? "Gord Dibben" wrote: You sure you are typing as Bernie suggests and it turns to 2005? i.e. 2/23/2007 or 23/2/2007 If a cell is formatted as date and you enter just 2007 you will get June 29,1905 Gord Dibben Excel MVP On Fri, 29 Apr 2005 08:26:05 -0700, zoemcb wrote: I was typing including the year in the date I typed - 2007, but as soon as I move on to another cell, the first cell changes from 2007 to 2005. Thanks anyway. "Max" wrote: Enter the full date, inclusive of the year, e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr Then format the cell to display the way you want (Format Cells Date Choose a type) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "zoemcb" wrote in message ... How can I stop excel from changing a date that I type (i.e 2007) back to 2005? I need the date to be in the future! But I can't figure out how to stop it from changing to 2005. Please help. |
|
#7
|
|||
|
|||
|
"Gord Dibben" wrote
Sorry about that Max. Don't know where I got Bernie from. No prob, Gord <bg. Thanks for helping out ! -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| How to stop excel replaceing numbers with the date? | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Linear Mode
