View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Cleese via OfficeKB.com John Cleese via OfficeKB.com is offline
external usenet poster
 
Posts: 4
Default International decimal number formats

You will be aware that some international number formats use ',' (commas) to
denote decimal places, whilst others use '.' (points). I have tried to write
a macro that will write a decimal number into a cell, and have tried to
define the number format by making use of lines:

Range("$A$1"),numberFormat = "0.0000"
OR
Range("$A$1").Value = Format(number,"0.0000")

Neither of these lines work.

I need to find a VBA command that will define the position of the decimal
place, regardless of whether the number format used by the user uses a '.'
(point) or a ',' (comma) to define the position of the decimal place.

Does anyone know how I can achieve this?

Regards

J

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1