Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2007 French Numeric Formats
Using XL2007 I want to format my numbers using the French format where commas
(thousands separators) are replaced by spaces and the decimal point is replace by a comma. I tried the following, to allow for numbers into the hundred millions: ###" "###" "###","## If I enter a number 123456789.15 I want it to change to 123 456 789,15 however it is appearing as 1 234 567,89 For some reason it is truncating the number. Can anyone please tell me how to correct this. Thank you -- LPS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2007 French Numeric Formats
If your system separators are set to comma = decimal point then this works
for me. ### ### ###,## get rid of the quotes. Gord Dibben MS Excel MVP On Fri, 30 Apr 2010 10:03:01 -0700, LPS wrote: Using XL2007 I want to format my numbers using the French format where commas (thousands separators) are replaced by spaces and the decimal point is replace by a comma. I tried the following, to allow for numbers into the hundred millions: ###" "###" "###","## If I enter a number 123456789.15 I want it to change to 123 456 789,15 however it is appearing as 1 234 567,89 For some reason it is truncating the number. Can anyone please tell me how to correct this. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formats XL2007 | Excel Discussion (Misc queries) | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
numeric cell formats | Excel Discussion (Misc queries) | |||
French numeric formats | Excel Discussion (Misc queries) |