Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
French to English translation of the name of an excel function | Excel Discussion (Misc queries) | |||
The function in French version DECALER is not working | Excel Worksheet Functions | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
TEXT function to format a date in English & French | Excel Worksheet Functions | |||
XL97/Win2K - lookup and return listing | Excel Programming |