Hi all
I import data from an accounting package.
the date column is causing me grief.
some data comes across ok as date format
but then some comes across as text.(but looks like date)
So it looks ok till I need to sort on date
The changes in format appear random down the column
If i use datevalue in the adjacent column it converts the text ok but leaves me with "VALUE" in the cells next to a correct date cell
How can i end up with a single column just in dateform?
tia kd
I import data from an accounting package.
the date column is causing me grief.
some data comes across ok as date format
but then some comes across as text.(but looks like date)
So it looks ok till I need to sort on date
The changes in format appear random down the column
If i use datevalue in the adjacent column it converts the text ok but leaves me with "VALUE" in the cells next to a correct date cell
How can i end up with a single column just in dateform?
tia kd