Date translations

H

hapitaron

Date translations


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

Thanks
;
 
F

Frank Kabel

Hi
iuf the values are stored as real date values simply change the
formting in 'Format - Cells'
 
M

Myrna Larson

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