Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of dates in the format xx.yy.zzzz. I want them to be displayed as the format xx/yy/zzzz. The cell format custom option does not convert the date from one to the other. How can I do this?
 
Ron Cardy said:
I have a column of dates in the format xx.yy.zzzz. I want them to be
Click to expand...
displayed as the format xx/yy/zzzz. The cell format custom option does not
convert the date from one to the other. How can I do this?

At the moment, you actually have text strings, not dates.

Select the column and use
Edit > Replace
Under "Find what:" put "." (without the quotes).
Under "Replace with:" put "/" (without the quotes).

This should convert to dates which you will then be able to format as you
wish.
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
Conditional formatting of date-cell - 2007 5
Date Formating Problem 1
Convert date to text without changing format dd/mm/yy 3
date format 1
Date Format Not Responding to MM/DD/YY 2
converting date to text 2
Preserving date format 1

Back
Top