Hi there,
Working in a global environment, I often need to export reports holding currency values.
Once in the .csv file I find "AUD1,234.15" for example.
When imported in Excel, this becomes a 'General' formatted field , which acts like a string.
So sorting as numericals is not possible.
Is there a way (during export out of Sugar, or import in Excel) to have these values as currencies in Excel ?
Thanks for your help,
;-)
Hugo
Hi D,
I tried that tip , but it doesn't seem to work as expected. Renaming to .txt and then open it via the Data menu from Excel allows me to change the field type , but if I change the original type to Currency or Decimal number , all values that are not net in my systems default currency, return an 'error'.
By the way , in my O365 setup when loading a .txt file , it gets sent to teh Power Query Editor.
I keep on looking ;-)
Bye now
Hugo
