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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|