how to change format of several dates entered in an Excel column

G

Guest

I have several dates (in fact over 100) already entered in the Date column in
"1 Jul 1854" format. This makes it impossible to run a meaningful sort by
Date. Is there a way to change these dates to a diffirent format like
"1854-07-01"? Of course, I'm not asking how to change every date manually.
I'd like to highlight this column and change all the dates at once.
All suggestions will be appreciated.
 
G

Guest

Thanks, Peo. I downloaded this applets and will try it. However, I still
don't know if it is possible to change format of already entered dates (after
1900).
Appreciate your help.
--
Ilya Zeldes
Fort Myers, FL


Peo Sjoblom said:
Excel dates start on Jan 0 1900 so anything earlier is text, John Walkenbach
has an add-in

http://j-walk.com/ss/excel/files/xdate.htm

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
Click to expand...
 

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

Help w/ cell shading across entire column-when a criteria has been 1
Sorting Dates 2
Conditional format Column based on Week Date 2
Change text format to date format 2
How to fill missing cells in the collumn of dates? 6
Text to dates 6
How can I sort "oldest to newest?" 5
Formatting dates in Excel 4

Top