title: Export original value to Excel keeping format only in Webi
body: <p>I am creating a report in Business Objects Web Intelligence, and there is a requirement to format a number in millions.  For example, $4,879,987.23 would be formatted as $4.9M.</p>
  
  <p>I tried both a custom  number format and a conditional format, and I can get it to display like I want, but when exporting to excel, I get $4.9M in the underlying data instead of $4,879,987.23 - the business I am creating this for really wants to see $4.9M, but be able to interact with the cell in Excel as if it is $4,879,987.23.</p>
  
  <p>Does anyone know if  there is a way to export from webi showing a ###.#M format, but using the actual number (###,###,###.##) in Excel?</p>