Hi
I have a sheet which needs to be used in multiple countries. On this sheet there is a date field and a time field.
I need to combine these into 1 cell with the following format
yyyymmddhhmmss
So i was doing a very simple formula of =IF(E2>0;TEXT(G2;"YYYYMMDD")&TEXT(H2;"HHMMSS");"")
However, this sheet is being used by multiple countries, so this formatting doesnt work. i end up with YYYY1020HH0000 (when a polish user uses it)
I have changed the format of the source date cell to read [$-409] which has worked ok, but not this formula
Any ideas how i can get excel to force the English version here or indeed a better formula?
Cheers
I have a sheet which needs to be used in multiple countries. On this sheet there is a date field and a time field.
I need to combine these into 1 cell with the following format
yyyymmddhhmmss
So i was doing a very simple formula of =IF(E2>0;TEXT(G2;"YYYYMMDD")&TEXT(H2;"HHMMSS");"")
However, this sheet is being used by multiple countries, so this formatting doesnt work. i end up with YYYY1020HH0000 (when a polish user uses it)
I have changed the format of the source date cell to read [$-409] which has worked ok, but not this formula
Any ideas how i can get excel to force the English version here or indeed a better formula?
Cheers