Le 27/04/01 19:48, « Peter Hall » <[log in to unmask]> a écrit :
> The help description for custom format suggests that you try
> #.##,,,
> each comma for the groups of 3 zeros that you'd like it to ignore.
> I suppose you can use 0.00 or similar instead of #.##
>
> Seems to work well.
>
> Peter
>
>> ===== Original Message From "(Association of Statistics Specialists Using
> Microsoft Excel)" <[log in to unmask]> =====
>> Does anyone know an easy way to format or rescale numeric values. I've got
>> numbers in the billions - 9,200,000,000. I'd like to display 9.2. I know
>> that I could divide everything by a billion, but I need to do this for a lot
>> of files.
>>
>> Any help is appreciated.
>>
Oops ! I must have stepped on one of those localization issues !
In France the blank is the thousands' separator. The comma for anglo-saxon
people.
Sorry.
François
|