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.
 

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

Creating Forms 0
Vertical short line in front of word 0
Match table shading (color) to Visio color/Transparency 1
Project Status Date 1
how do I convert date format yyyymmdd to mm/dd/yyyy 2
Formatting templates 7
Display weeks from a Milestone 0
Inserting slashes in dates in Excel 1

Top