K
Keith Sircombe
Is there a way of doing a global update of a custom date
format?
The issue is thus:
* We have a set of data with a particular date format, but
we need to convert to "dd/mm/yyyy h:mm" format for
subsequent saving as a text file.
* We can select the relevant column and change the format,
but the chnage is not immediately reflected in the
contents of the selected cells.
* The only way we have found to make the change is to
select *each* cell individually and press return.
* This is a grossly inefficient way considering we have
files that contain up to a hundred lines of data.
I've searched all the usual help files and can't find
anything of relevance. Any suggestions (or confirmations
it can't be done more easily) appreciated!
Keith.
format?
The issue is thus:
* We have a set of data with a particular date format, but
we need to convert to "dd/mm/yyyy h:mm" format for
subsequent saving as a text file.
* We can select the relevant column and change the format,
but the chnage is not immediately reflected in the
contents of the selected cells.
* The only way we have found to make the change is to
select *each* cell individually and press return.
* This is a grossly inefficient way considering we have
files that contain up to a hundred lines of data.
I've searched all the usual help files and can't find
anything of relevance. Any suggestions (or confirmations
it can't be done more easily) appreciated!
Keith.