Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel question Formats and number pad | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
International number separator | Excel Worksheet Functions | |||
number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) |