Date cell format

  • Thread starter Thread starter Avi
  • Start date Start date
A

Avi

Hi experts,

I got an Excel sheet with a text column with a series of digits like
08182005 representing date (mmddyyyy). I tried to use cell format to make
Excel recognize it as date, but I was not successful.
Once Excel recognizes it as date I would like to convert in to the format
(DD/MM/YYYY)

Thanks,
Avi
 
If the values are all 8 digits, select the column, choose Data/Text to
Columns..., click Next, Next, and select MDY from the Date dropdown.
Click Finish.

Format as you like.
 

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 to enter a date in DD-MM-YYYY format 2
date format convert 2
Excel not recognizing date formats 3
Default date format 4
Date Format Problem. 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
Formatting Cells Containing Date Fields That Are Text 3
converting text to proper dates 6

Back
Top