|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2010, 04:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
I'M DOING A SPREADSHEET AND WHEN I PUT DATES IN THE COLUMN IT AUTOMATICALLY
CHANGES TO A FUTURE DATE. NOT SURE WHAT I'M DOING WRONG 
|
|
#2
May 21st, 2010, 04:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
NOT SURE WHAT I'M DOING WRONG
How could we be, if we don't even know what you're doing? What *exactly* do you type and what appears in the cell? Did you format the cells and if so, how? Please don't type in all capitals. It is considered shouting. -- Kind regards, Niek Otten Microsoft MVP - Excel "LADYBIRDDI" wrote in message ... I'M DOING A SPREADSHEET AND WHEN I PUT DATES IN THE COLUMN IT AUTOMATICALLY CHANGES TO A FUTURE DATE. NOT SURE WHAT I'M DOING WRONG
|
|
#3
May 21st, 2010, 08:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
On May 21, 11:12*am, LADYBIRDDI
wrote: I'M DOING A SPREADSHEET AND WHEN I PUT DATES IN THE COLUMN IT AUTOMATICALLY CHANGES TO A FUTURE DATE. NOT SURE WHAT I'M DOING WRONG You may be entering mm/dd/yyyy when your Excel is formatted for dd/mm/ yyyy (or vice versa). Thus when you enter 5/11/2010 thinking that is is May 11 2010, the date as formatted shows up as Nov 5 2010.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
