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, |
Using Round function on French and US Win2k
Since you're posting to "programming" and talk about a variant, I take it
you're talking about VBA. Well, I'm a bit surprised there is this difference; I thought VBA would always adopt the US convention, like it does for dates. But I don'y think you need to worry; most international issues are handled correctly by Excel, which keeps formulas, data and formats in a language-independent internal notation. Exceptions are where those characteristics are in literals, like in format strings for the TEXT() function, the INDIRECT() function if you apply R1C1 reference style, etc. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Pallavi Singh" wrote in message ... 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, |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com