Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month day confusion
When working with worksheets from other countries Excell will confuse month
and days. How can I correct this - change what excell thinks is a month to a day - and vise versa. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month day confusion
Excel does not confuse them. The dates are stored as numbers, and
represented according to the formatting. This formatting may be "wrong" for you: FormatCellsDate, pick a format you like. There are exceptions. If you import csv files for instance, or in certain cases if you fill your cells from VBA. For "normal" worksheet use, however, just reformatting should do. -- Kind regards, Niek Otten "VPH" wrote in message ... When working with worksheets from other countries Excell will confuse month and days. How can I correct this - change what excell thinks is a month to a day - and vise versa. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
YEAR and MONTH confusion | Excel Worksheet Functions | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions |