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.
 
Back
Top