Output currency in Excel as number not string

I am having trouble outputting data into Excel. I have invoices that include dollar amounts, but when I output to Excel in order to have the dollar sign I have to convert to a string.

Is there any way to output a column of currency as a number in Excel instead of a string?

Output

Accepted answers

danrh

Look into the Reporting tools. I used the Table tool to add a "$" prefix, then a Render tool to output. In the resulting excel file, the number format ends up as "Currency" rather than text.

Hope it helps!

solution.yxmd

All comments

danrh

Look into the Reporting tools. I used the Table tool to add a "$" prefix, then a Render tool to output. In the resulting excel file, the number format ends up as "Currency" rather than text.

Hope it helps!

solution.yxmd

RMotiwalla

Thank you danrh!!

brindhan

I just tried this, and it works fine except for negative number which still remain as text on the excel output. I realized this is because I used a layout too later to arrange tabs...a warning saying "the current page layout will cause some data to be truncated" Any ideas?

Ok problem solved- I had to change my report size into something bigger, thats all.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335