changing date format not working

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

Guest

After selecting a column and changing format to custom date yyyymmdd. The
changes do not take place. Double Clicking in the individual cells
afterwards bring up the desired results.
 
Your dates were entered as Text, which isn't subject to Number Formats.

You can coerce them back to XL dates by copying a blank cell, selecting
your dates and choosing Edit/Paste Special, selecting the Values and Add
radio buttons.

Change the format to your desired one.
 
Thanks for the help

JE McGimpsey said:
Your dates were entered as Text, which isn't subject to Number Formats.

You can coerce them back to XL dates by copying a blank cell, selecting
your dates and choosing Edit/Paste Special, selecting the Values and Add
radio buttons.

Change the format to your desired one.
Click to expand...
 
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

Formatting the date 1
How do I convert date/time formats differently? 4
Excel date format YYYYMMDD 1
How do I change the date format? 3
date format will not change in Excel 3
Date Format Not Responding to MM/DD/YY 2
Date Formating Problem 1
Date Conversion 6

Back
Top