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?