If all those "dates" are in a single column, you could even use Data|text to
columns.
Use YMD as the field format.
Then format that column the way you want.
Gilles Desjardins wrote:
Hi everyone,
I receive data from an old database program like this:
19910224. I need to convert to a date format in order to use the datedif()
function.
The final product should be 24-Feb-1991 OR 1991-02-24 in date format.
Formatting like the latter example does not help. My "numbers" do not
convert to dates. All I achieve is 1991-02-24 and I can't use datedif.
Can anyone help.
TIA
Gilles Desjardins
--
Dave Peterson
|