Hi, when I convert a Numbers file to CSV and export it to a program (Fortnox).
Fortnox can't read negative numbers(ex -519,00). I have tried to delete minus and put it in again but still the same problem...
Anyone has a solution?
BR
O
iMac, macOS 10.13
As far as I can tell, Numbers uses the standard hyphen/negative symbol for the minus sign (ASCII code 45) when it exports negative numbers to CSV. But we have noticed in the past that there are regional differences in how Numbers works. Something that works perfectly fine in the US region might not work the same in another region.
As a test, do you have another spreadsheet app (Excel, Google Sheets, etc.) you can use to import the CSV file to see if negative numbers get imported as numbers, not text? The test is to be sure they import as numbers, not text. That will rule out it being a problem with negative symbols in the CSV. If it passes that test, the problem is something about Fortnox.
Does Fortnox require negative numbers to be formatted with parentheses as (519,00) vs -519,00 ? That would be strange but it is a possibility. You could try formatting all numeric cells to use parentheses for negatives. The exported CSV will/should also use parentheses. As a test (before messing with your Numbers document), you can edit the CSV file you have now and change one or more of the negatives into that format and see if those numbers import correctly into Fortnox.
As far as I can tell, Numbers uses the standard hyphen/negative symbol for the minus sign (ASCII code 45) when it exports negative numbers to CSV. But we have noticed in the past that there are regional differences in how Numbers works. Something that works perfectly fine in the US region might not work the same in another region.
As a test, do you have another spreadsheet app (Excel, Google Sheets, etc.) you can use to import the CSV file to see if negative numbers get imported as numbers, not text? The test is to be sure they import as numbers, not text. That will rule out it being a problem with negative symbols in the CSV. If it passes that test, the problem is something about Fortnox.
Does Fortnox require negative numbers to be formatted with parentheses as (519,00) vs -519,00 ? That would be strange but it is a possibility. You could try formatting all numeric cells to use parentheses for negatives. The exported CSV will/should also use parentheses. As a test (before messing with your Numbers document), you can edit the CSV file you have now and change one or more of the negatives into that format and see if those numbers import correctly into Fortnox.
You have found you can import it into Excel and it imports the negative numbers as actual numbers, not text. The part about them being actual numbers, not text-formatted numbers was the important part. Actual numbers will align in Excel on the right side of the cell, text "numbers" will align on the left side of the cell. So if that was all okay, it sounds like the CSV is fine. Try one more test:
Now export/save it from Excel as CSV and see if Fortnox can import that file. If it can, open both CSV files in TextEdit or BBEdit or another plain-text editor (not Excel Word) and see if you can find the difference(s). If Fortnox cannot import the one from Excel, then it is most likely a Fortnox problem or some incompatibility with it and a setting on your computer.
Is Fortnox an online app (web-based) or is it an app that you installed and run on your computer?
Fortnox is web-based, and it can import when we do excel - csv. But I have read that Number is not compatible with Fortnox. But when I export from Numbers to CSV it read everything but the negative numbers… It’s a ; csv
It works from Excel, and it doesn't work with (519) I have talked to Fortnox and they says ham not the first with this issue and its an Apple problem. And then I talked to Apple they say call Fortnox...
Convert Numbers to csv
