Apologies that the title isn't a little clearer!
I am using Excel to generate scripts for a game that I play. I use a series of text boxes and commands and then join them together in one cell. The relevant part of the text of the formula is
="Deploy" .....&TEXT(J10,"hh:mm:ss") (where J10 is a calculated time)
And this gives the result:
Deploy .... 21:23:46
It works perfectly for me. I created it in 2010 but also use it in 2003, and get the results that I need.
However, when I sent this file to a friend in a different country (not sure that's relevant), also using excel 2003, the result he gets is
Deploy.... hh:23:46
If he saves the file and sends it back to me, it is still correct on my pc.
I have also used "concatenate", but same thing happens. I am presuming it is a setting on his side, but have no clue what it could be. Any ideas?
Thanks in advance![]()
Bookmarks