Right-click on the cell(s) FormatCells NumberTab Custom then type
YYYYMMDD in the Type: window OK

Vaya con Dios,
Chuck, CABGx3



"nick" wrote:

Hi,

I have a file with dates in custom format mm:ss.0. When i double click on
that cell, the format changes to m/d/yyyy h:mm. I need to change these
formats in to a julian date or yyyymmdd format. Can anyone help? thanks