Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell (to show Mar-09) it automatically goes to Mar-08
Trying to format the column, I type in 3/09 wanting it to show Mar-09 and it
automatically goes to Mar-08 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell (to show Mar-09) it automatically goes to Mar-08
3/9/2009 -- Don Guillett Microsoft MVP Excel SalesAid Software "Nat" wrote in message ... Trying to format the column, I type in 3/09 wanting it to show Mar-09 and it automatically goes to Mar-08 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell (to show Mar-09) it automatically goes to Mar-08
Hi,
Don is correct, of course. But why? If you check your formula bar after you type 3/09 you will see that Excel figured you ment 3/9/2008. Excel has to guess what the 9 means - the month or the year, it goes for month and assumes the current year. If you typed 3/32 excel would know this could not be a day of the month so it would assume you wanted the first, 3/1/1932. -- Thanks, Shane Devenshire "Nat" wrote: Trying to format the column, I type in 3/09 wanting it to show Mar-09 and it automatically goes to Mar-08 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a cell (to show Mar-09) it automatically goes to Mar-08
.. type in 3/09 wanting it to show Mar-09 and it
automatically goes to Mar-08 Always be unambiguous when it comes to dates Enter the whole date (including the YEAR) -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically show modified date? | Excel Worksheet Functions | |||
automatically show date day by day | Excel Worksheet Functions | |||
I want a cell to show the current filename automatically. | Excel Discussion (Misc queries) | |||
Expired date to show up automatically | Excel Discussion (Misc queries) | |||
How I show, automatically, the tab name on a cell, in Excel? | Excel Worksheet Functions |