Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date format in Excel
Hi All,
What a wonderful mine of information this group is!!! Required daily reading to me. Thanks for the great contributions. Although I have managed to format a cell date (Excel in Office Pro 2000) with the "day" (e.g. "Friday" - as in dddd, dd mmm yyyy), I am stumped when it comes to putting a "th" or "nd" or "rd" (as in 1st/2nd/3rd etc...) Any ideas? TIA -- mac |
#2
|
|||
|
|||
Take a look he
http://cpearson.com/excel/ordinal.htm In article , "mac@bath" wrote: Hi All, What a wonderful mine of information this group is!!! Required daily reading to me. Thanks for the great contributions. Although I have managed to format a cell date (Excel in Office Pro 2000) with the "day" (e.g. "Friday" - as in dddd, dd mmm yyyy), I am stumped when it comes to putting a "th" or "nd" or "rd" (as in 1st/2nd/3rd etc...) Any ideas? TIA |
#3
|
|||
|
|||
or a formula solution http://www.xldynamic.com/source/xld.RANK.html
-- HTH RP (remove nothere from the email address if mailing direct) "JE McGimpsey" wrote in message ... Take a look he http://cpearson.com/excel/ordinal.htm In article , "mac@bath" wrote: Hi All, What a wonderful mine of information this group is!!! Required daily reading to me. Thanks for the great contributions. Although I have managed to format a cell date (Excel in Office Pro 2000) with the "day" (e.g. "Friday" - as in dddd, dd mmm yyyy), I am stumped when it comes to putting a "th" or "nd" or "rd" (as in 1st/2nd/3rd etc...) Any ideas? TIA |
#4
|
|||
|
|||
Many thanks to you both.
I just KNEW that someone out there would know this. (But google didn't.) However... Having seen the complexity of the answers (especially xldynamics !!) I'm going to live with the fact that the date at the top of my spreadsheets can go WITHOUT the "st/nd/rd" !!! I'm not THAT brave with formulae! Thanks anyway. -- mac "mac@bath" wrote: Although I have managed to format a cell date (Excel in Office Pro 2000) with the "day" (e.g. "Friday" - as in dddd, dd mmm yyyy), I am stumped when it comes to putting a "th" or "nd" or "rd" (as in 1st/2nd/3rd etc...) Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |