Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default Urgent! PIVOT TABLE FIGURES REQUIRED IN MILLIONS

I have a pivot table based on a very large sheet! I want the figures to be
reported in, and rounded off to, millions.

How can I achieve the same

Best Regards,
FARAZ A. QURESHI
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 56
Default Urgent! PIVOT TABLE FIGURES REQUIRED IN MILLIONS

FARAZ QURESHI wrote:
I have a pivot table based on a very large sheet! I want the figures to be
reported in, and rounded off to, millions.

How can I achieve the same


Devide by 1000000

houghi
--
This was written under the influence of the following:
| Artist : Die Toten Hosen
| Song : Das Wort zum Sonntag
| Album : Bis zum bitteren Ende
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Range Pivot Table (Urgent Please) FARAZ QURESHI Excel Discussion (Misc queries) 0 September 15th 07 06:28 AM
URGENT! Retain format of cells in pivot table upon refresh KDG Excel Discussion (Misc queries) 3 September 10th 07 10:02 AM
URGENT PLEASE! Filtering a Pivot Table further hile trotman Excel Worksheet Functions 4 February 1st 07 04:32 PM
pivot table error.Please help! very urgent anu_manu Excel Discussion (Misc queries) 0 February 13th 06 08:34 PM
Hide 0% figures in Pivot Table Matt D Francis Excel Worksheet Functions 4 November 4th 05 09:46 AM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"