| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
override language settings on date
I have the following formula TEXT(E34,"yymmdd")&"-"&$C$5&"-DrawingList.PDF
It work ok on my computer, but on my colleague's there is some general language setting that makes excel only recognise "jjmmdd". We cannot find immediatly the setting (all the software is in English) and anyway we would prefer not to change it. How can we make sure the formulas work independently of the local computer settings? Thanks? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Hybrid Mode
