Save formatting for re-use with new data?
 

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

Save formatting for re-use with new data?
 

Hi

In your Invoice system, how are you formatting date?

With formulae to have just the date without time it would be
=TEXT(yourdate,"dd/mm/yyyy")
or
=INT(yourdate)

With VBA
format(yourdate,"dd/mm/yyyy")

--
Regards
Roger Govier

"CW" wrote in message
...
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

Save formatting for re-use with new data?
 

Roger -
Many thanks for your response. The invoices are coming out of our Access
database, and no matter what I do in there, it seems that I cannot prevent
the time coming out with the date - hence my attempt to suppress it once it
gets into the csv file!
Thanks
CW

"Roger Govier" wrote:

Hi

In your Invoice system, how are you formatting date?

With formulae to have just the date without time it would be
=TEXT(yourdate,"dd/mm/yyyy")
or
=INT(yourdate)

With VBA
format(yourdate,"dd/mm/yyyy")

--
Regards
Roger Govier

"CW" wrote in message
...
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