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.
>
>
>__________________________________________________
>
>Catherine Shenoy, University of Kansas, School of Business
>1300 Sunnyside Ave, 313D Summerfield Hall
>Lawrence, KS 66045-7585
>(785) 864-7519, [log in to unmask]
>__________________________________________________
Mathematics Department
Tonbridge Grammar School for Girls
Deakin Leas
Tonbridge
Kent
TN9 2JR
(01732) 365125
|