Date format when exporting data from Sage Line 50 into Excel

A

Averil

I've exported loads of bank transactions from Sage Line 50 V11 into Excel,
and want to sort by transaction date. I dimly remember that I need to
transform the Sage dates from text by the use of DATEVALEU, but cant seem to
get the syntax. Any suggestions, please?
Averil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i connect to Sage Line 50 v12 from Excel 2007? 1
import html table ( which has been exported from sage line 50) 1
importing from sage (line 50)... 0
Formatting Numbers in Excel 1
Macros to convert Data into date format and then plot in graph 7
date format - excluding year 3
changing a string date into a 'date' 4
Exporting Data to Excel-Date Format Changed 3

Top