Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format problem
In my Excel files,when I click a cell that contain "date" it changes
into dd/mm/yyyy format.But,in the formula bar,the same date is displayed in mm/dd/yyyy format.Why it is so? I want all the dates in dd/mm/yyyy format only.Will there be any problem while sorting if the date column contais dates of different formats i.e. dd/mm/yyyy and mm/dd/yyyy as well? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format problem | Excel Discussion (Misc queries) | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
Please can anyone help me? Big problem with date format. | Excel Programming | |||
date format problem?? | Excel Discussion (Misc queries) | |||
Date Format problem | Excel Programming |