Hello,

I have data in Excel (via an SSAS cube) where the values are shown in thousands of dollars.  The numeric value is 1234.567 which represents $1,234,567.  Normally I'd just divide it by 1000 to move the decimal point back, but I can't do that within the pivot table that is linked to the SSAS data cube.

So is there a way to use a custom number format to move the decimal three spaces to the right?  I can go the other way using $0.000, (which returns $1.235), but I need to shift it to the right, so it shows $1,234,567.

Any ideas? 

• Moved by Lanlan HuangMicrosoft contingent staff 6 hours 3 minutes ago

Re:  format thousands to millions

An alternative...

  $0.000," MM"

'---
Jim Cone
Portland, Oregon USA

Hi

This is the forum to discuss questions about Microsoft Excel develop (VBA). For your question is about format in Excel, I will move this question to the TechNet forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards

Lan