Date translations

  • Thread starter Thread starter hapitaron
  • Start date Start date
H

hapitaron

Date translations


I want to convert a date templet that I have YYYYMMDD to America
standard date MMDDYYYY

Thanks
;
 
Hi
iuf the values are stored as real date values simply change the
formting in 'Format - Cells'
 
Select the column containing the dates, then Data/Text To Columns. On the 3rd
dialog box of the Wizard, under Column Data Format, select Date, and pick YMD
from the dropdown. Click OK.
 
You must log in or register to reply here.

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

how do I convert date format yyyymmdd to mm/dd/yyyy 2
How can we convert OST to PDF file format? 1
Date Conversion 2
Converting Text to Date 3
JULIAN DATES? 8
Date Conversion 6
change date format 2
how do I change the date format from yyyymmdd to mm/dd/yyyy 4

Back
Top