Hello
By the way this is not just about changing the $ sign.
I have to a download monthly accounts spreadsheet from a sister company in Denmark.
Numbers are shown as: 99.999.99
with the comma and the period switched.
The Danish accounting software will only download in this format.
I receive it in webpage format and save as an Excel workbook xlsx.
I'm trying to consolidate the Danish results with the other companies using normal formatting and it's impossible to work with these numers in my regular copy of Office 365 Excell 2013
My question is how can I change the whole downloaded workbook to show numbers in the normal format: 99,999.99?
I've spent too mush time on this without resolving the issue and would be very grateful for any suggestions.
Thanks
Charles
[TABLE="width: 95"]
<tbody>[TR]
[TD="class: xl63, width: 95"][/TD]
[/TR]
</tbody>[/TABLE]
By the way this is not just about changing the $ sign.
I have to a download monthly accounts spreadsheet from a sister company in Denmark.
Numbers are shown as: 99.999.99
with the comma and the period switched.
The Danish accounting software will only download in this format.
I receive it in webpage format and save as an Excel workbook xlsx.
I'm trying to consolidate the Danish results with the other companies using normal formatting and it's impossible to work with these numers in my regular copy of Office 365 Excell 2013
My question is how can I change the whole downloaded workbook to show numbers in the normal format: 99,999.99?
I've spent too mush time on this without resolving the issue and would be very grateful for any suggestions.
Thanks
Charles
[TABLE="width: 95"]
<tbody>[TR]
[TD="class: xl63, width: 95"][/TD]
[/TR]
</tbody>[/TABLE]
