| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change date default
When I open a new file and I insert in a cell some date (like 10-04) it
doesn't appears the current year, I would like to change it to always appears 10-04-07. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change date default
Does it appear in the formula bar with the correct year?
If so pre-format the cell as dd-mm-yy or mm-dd-yy depending on your date system. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Patrícia Maff" <Patrícia wrote in message ... When I open a new file and I insert in a cell some date (like 10-04) it doesn't appears the current year, I would like to change it to always appears 10-04-07. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change date default
If you don't get 10-04-07 what do you get?
-- Regards, Peo Sjoblom "Patrícia Maff" <Patrícia wrote in message ... When I open a new file and I insert in a cell some date (like 10-04) it doesn't appears the current year, I would like to change it to always appears 10-04-07. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change the default from a date to a number? | Excel Discussion (Misc queries) | |||
| change date default settings | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| How to manage/change the default month/day date format? | Excel Discussion (Misc queries) | |||
| How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
Linear Mode
