Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring number formats across international locales
I need to be able to store decimal numbers in excel cells that are as
recognisable in all international number formats, as they are in my own international locale format. 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 the lines: Range("$A$1"),numberFormat = "0.0000" OR Range("$A$1").Value = Format(number, "0.0000") -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Outline different number formats | Excel Discussion (Misc queries) | |||
Custom number formats | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions |