Formatting the date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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) > FormatCells > NumberTab > Custom > then type
YYYYMMDD in the Type: window > OK

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Conversion 1
How do I change the date format? 3
Excel date format YYYYMMDD 1
Length of time from date/time custom format 2
Date / Time Filter 2
test to Julian date 10
Date Format Problem (bug) 5
Formatting Date 4

Back
Top