software

I'd like my Pivot Table number to expressed in thousands (000's)--any ideas?

Custom format #,###,

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Excelablequot; gt; wrote in message
...
gt; I'd like my Pivot Table number to expressed in thousands (000's)--any
gt; ideas?
Hi there,

select the figures you want to format and Format Cells/numbers/Custom
and # ## ,00 (with a 1 space at the end. 2 spaces will have 000,000s)

NB the figures in PT will remain exact numbers, only the format will reveal
the 000s.

Hope, this helps,

Best regards,
ANdras
(Hungary)

quot;Excelablequot; wrote:

gt; I'd like my Pivot Table number to expressed in thousands (000's)--any ideas?