File export to excel

j.cattell's Avatar


29 Mar, 2023 09:43 AM

In the most recent version of the software that I have there has been a change to the way in which the currency values are exported. I am using pounds Sterling and when I save a file to csv format it outputs a strange symbol (Â) in front of the £ sign then a space before the numeric part. I used to import the file and then run a macro but I now have to replce all the  synbols before I can do it.
I thought I would try to use the export version called CSV formatted for Excel but that is worse because it requires you to import the file as if it were a text file and you have to go through loads of formatting before you can use it.
Can there not be a version that excel can just open ?

I have just noticed that I am using version 2022.6. Does the 2023 update address the problem?

  1. 1 Posted by j.cattell on 01 Jun, 2023 06:23 PM

    j.cattell's Avatar

    It is 2 months since I posted this and there has been no response.
    Does anybody have an answer?

  2. 2 Posted by Stuart Beesley ... on 01 Jun, 2023 06:52 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You can use Extension, Extract_Data. This creates CSV extracts that you can just double click to open in excel...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac