Hi All
Is there a way to turn '21st April 1813' into '21 Apr 1813' in Excel.
Usually in a register I get a date like 21st April in one column and 1813 in the next.
OK I can concatenate (whatever) and join them together but still have to abbreviate the month and get get rid of the st in the day.
I could use find and replace but with a load of dates that would take ages.
Any Ideas
Results 1 to 7 of 7
Thread: Dates in Excel.
-
14-10-2009, 7:14 PM #1Mike BGuest
Dates in Excel.
-
14-10-2009, 7:24 PM #2
Mike
Depends where the dates are, if all in one column, you can highlight the column and rightclick and select format cells. If the style you want isn't shown in the dates section, I believe you can select custom and make your on style.
Good luckNeil
www.claycross.org.uk
-
14-10-2009, 7:29 PM #3Mike BGuest
Hi Neil
I've tried that one. No luck!
-
14-10-2009, 7:38 PM #4
- Join Date
- May 2009
- Location
- cambridge
- Posts
- 1,084
If you format your cells as text it will work, but you have to type in the date as you want it.
-
14-10-2009, 7:42 PM #5Mike BGuest
I've hundreds of them.
-
14-10-2009, 8:34 PM #6GeoffersGuestOriginally Posted by Mike B
-
14-10-2009, 8:41 PM #7Mike BGuest
Hi Geoffers
That was the only way I knew I could do it using many Replace commands or writing a mcaro that would do it all at the press of a button.
I was hoping I could use a function like left right or mid that would instantly edit each entry.
Helping you trace your British Family History & British Genealogy.
All times are GMT. The time now is 11:10 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2024 vBulletin Solutions Inc. All rights reserved.
Bookmarks