| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format date with specific regional format
I am working in a international group where users have different regional
settings: UK, Denmark, Turkey. I want dates to always show in UK format, even when regional setting is another country. I need this to work in: 1) ordinary cell format 2) using TEXT() function to construct text expressions using dates. In Excel 2003, I remember it was possible to insert a regional code number in brackets into a custom cell format. Is this possible in Excel 2007? Would this work in the TEXT() function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Forcing a specific date format | New Users to Excel | |||
| regional number format | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
Threaded Mode
