Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting of date
Hello,
I have on a spreadsheet a column for dates. The dates are entered in the format dd/mmm/yyyy and then the cell formatting changes them to mmm-yy. This works fine for all UK users, but it all goes pear shaped when people abroad add dates. In this case the format of the cell is overridden with another format and foreign spelling. For example, if I entered 12/oct/2008 in the UK, the cell would display Oct-08. However when a Dutch person does it for the same date 12-Okt-2008 is displayed. Not only is the formatting wrong, but the word Okt instead of Oct is present. I have a macro which used the "Oct" part to count the number of entries per month and this issue is messing it up. Is there any way to force the dates into UK format? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Formatting Date | Excel Discussion (Misc queries) | |||
date formatting | Excel Discussion (Misc queries) | |||
XML Date formatting | Excel Discussion (Misc queries) | |||
formatting date | Excel Worksheet Functions |