close
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
Right-click on the cell(s) gt; FormatCells gt; NumberTab gt; Custom gt; then type
YYYYMMDD in the Type: window gt; OK
Vaya con Dios,
Chuck, CABGx3
quot;nickquot; wrote:
gt; Hi,
gt;
gt; I have a file with dates in custom format mm:ss.0. When i double click on
gt; that cell, the format changes to m/d/yyyy h:mm. I need to change these
gt; formats in to a julian date or yyyymmdd format. Can anyone help? thanks
全站熱搜
留言列表
