I'd like my Pivot Table number to expressed in thousands (000's)--any ideas?
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
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"Excelable" <[email protected]> wrote in message
news:[email protected]...
> I'd like my Pivot Table number to expressed in thousands (000's)--any
> 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)
"Excelable" wrote:
> I'd like my Pivot Table number to expressed in thousands (000's)--any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks