View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pallavi Singh Pallavi Singh is offline
external usenet poster
 
Posts: 6
Default Using Round function on French and US Win2k

I have a date in a variant.
On win2k US when i see the values it shows 1076085062.623856.
On win2k French when i see the values it shows 1076085062,623856.

So the decimal is replaced by a comma in the french version of win2k.

i wonder if i use the round function will they produce the same result or
any one will give me an error or an unexpected result.
I have a US win2k version and cannot test this on the french version.

i.e. Can I use Round function for trimming values where the number format is
different ,for example "1234.5678" (US) and "1234,5678" (french)
Thanks in advance.

Regards,