Make Excel exports usable by exporting number fields for all numbers - not TEXT with $
When I go to the "Financial Reports" and "Export Extended Data" it produces an Excel spreadsheet. The problem with that sheet is that the dollar values for all the rent, fees, etc come out in the spreadsheet as a TEXT field ($100) instead of a number (100), so the data cannot be used to add up a total because it's TEXT and not a NUMBER. Surely this can be easily fixed by your development team so these spreadsheets come out ready to use.
Wynn Jones
shared this idea
-
AdminThien (Admin, Hostfully) commented
HI Wynn. Thank you for your idea. The reason why we put a symbol is to let customers know the currency they are using since we have many customers that use different types of currency.
Excel is a powerful tool for editing and collecting data. With simple formula or filter in Excel, your accountant should be able to change text to number.
But we really value your feedback. Our engineers will put this idea on a list based on the number of votes for it.