Send To Excel Creates Columns at Every Comma
Kate Clark
2024-09-13
To stop receiving notifications on forum posts unmark the star icon macOS
When I send a report to Excel, the data is split into a separate column everywhere there is a comma, which is making all of my Excel exports unusable because none of the data in the columns line up correctly. (Sales, Inventory, Goods Receipts, etc)


Quantities, Price, Customer names - anything with a comma in it is getting split into separate columns - I've attached a screenshot showing what is happening.

It did not used to do this, it must have been since our most recent update, we're on version 8.5 2024-08-05.

Is this a report setting? Can someone help me, please? I would really appreciate it.

Kate
Files are pending for approval
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
ConsulBiotech, Investigação e Desenvolvimento, Unipessoal, LDA
Boa tarde, O Standard accounts aparentemente não liga ao servidor CIEDUL e consequentemente as mi...
14:42 24 Oct 2024
HC
Boa tarde, uma vez mais solicitamos resposta à questão colocada. ...
15:13 21 Oct 2024

Supervisionamos regularmente o fórum dentro do horário normal de trabalho e tentamos responder a todas as questões em 24 horas

Pode subscrever notificações para qualquer mensagem neste fórum, seleccionando o ícone 'estrela' no canto superior direito da lista de tópicos. Tem de iniciar sessão para utilizar esta funcionalidade.