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
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
Excel does not confuse them. The dates are stored as numbers, and
represented according to the formatting.
This formatting may be "wrong" for you: Format>Cells>Date, 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks