Prev: Sharing Violation
Next: Need to import a table done in PDF into Excel
From: LPS on 30 Apr 2010 13:03
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
From: Gord Dibben on 30 Apr 2010 15:43
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 <LPS(a)discussions.microsoft.com>
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

 | 
Pages: 1
Prev: Sharing Violation
Next: Need to import a table done in PDF into Excel