LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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,


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
French to English translation of the name of an excel function Clovis Excel Discussion (Misc queries) 3 April 9th 10 04:33 AM
The function in French version DECALER is not working AK Excel Worksheet Functions 2 June 22nd 08 07:47 PM
opening up an english excel sheet onto a french verions - problems with edate function [email protected] Excel Discussion (Misc queries) 0 February 20th 05 01:37 PM
TEXT function to format a date in English & French IanC Excel Worksheet Functions 2 December 16th 04 01:59 PM
XL97/Win2K - lookup and return listing Tim R[_2_] Excel Programming 0 November 19th 03 07:06 PM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"