Formula giving different result on two different pcs

[mdooley]

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

[NBVC]

your friend may need to adjust the "hh:mm:ss" part for his country... since you have it between quotes, Excel sees it as a text string so doesn't translate it properly...

tell them to replace the "hh" with the first letter of the way they say "hour" in their language (same letter twice)...

[mdooley]

Thank you! Makes sense that would be it. I will try it. Thanks again.