software

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.
ThanksExcel does not confuse them. The dates are stored as numbers, and
represented according to the formatting.
This formatting may be quot;wrongquot; for you: Formatgt;Cellsgt;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 quot;normalquot; worksheet use, however, just reformatting should do.

--
Kind regards,

Niek Otten

quot;VPHquot; gt; wrote in message
...
gt; When working with worksheets from other countries Excell will confuse
gt; month
gt; and days. How can I correct this - change what excell thinks is a month
gt; to a
gt; day - and vise versa.
gt; Thanks
gt;