Date format problem

[Bush Kangaroo]

Hello

I am having great difficulty in converting American date format int
dd/mm/yy. I have used both the date format option and also the custo
option, this has not been sucessful. I have attached a small dat
sample and I would greatly appreciate if someone could provide som
assistance in converting these dates.

The dates are exported from an ERP system which operates the julia
date system...unsure if this is the reason why I can't sucessfull
convert all dates???!

regards

A

Attachment filename: date format.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54036

 

[DNF Karran]

The dates on the spreadsheet are text strings not numbers so the dat
format will not work. (Dates in excel are actually numbers with
special format applied)

You will be best fixing this at the import stage and then changing th
format to custom dd/mm/yy

Dunca