C
CW
Every week we export invoice data from our orders system into a .csv file
(InvoiceExport.csv), which we then import into the accounting system (Sage
Line 50, a UK product).
The invoice date includes the time (as 00:00). Unfortunately Sage will not
accept this so after creating the .csv we have to manually format that column
to just the date.
Is there any way that I can save the InvoiceExport.csv worksheet and
preserve the formatting in that column so that when fresh data is saved into
it, it will store just the date and not the time as well?
Many thanks
CW
(InvoiceExport.csv), which we then import into the accounting system (Sage
Line 50, a UK product).
The invoice date includes the time (as 00:00). Unfortunately Sage will not
accept this so after creating the .csv we have to manually format that column
to just the date.
Is there any way that I can save the InvoiceExport.csv worksheet and
preserve the formatting in that column so that when fresh data is saved into
it, it will store just the date and not the time as well?
Many thanks
CW