When entering a date can this be done so it reads 1st, 2nd, 3rd etc for when we do a mail merge?
When entering a date can this be done so it reads 1st, 2nd, 3rd etc for when we do a mail merge?
Please read your question again, and read it hrough our eyes (the forummembers you are willing to help you).
Would you understand what the question is?
Would you have all information to give an answer?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
When I enter a date for example 08/06/2014 can this be shown in the cell as 8th June 2014 the only way I can find this is 08 June 2014.
Hi wjb1976,
Hope this formula helps you :
=TEXT(D1,"dddd, mmmm d")&MID("stndrdthstndrdthst",MATCH(DAY(D1),{1,2,3,4,21,22,23,24,31},1)*2-1,2)
Where D1 is the cell where you enter Input value.
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
It has to be in the same cel?
I don't think that can be done with excel formula / format.
Maybe it can be done with VBA.
If it is possible to use another cell, i think i will be possible.
Thank you for your help
@wjb1976
It's an working solution for you?
if so will you mark the question solved?
Hi wjb1976,
Made some changes in the formula, this will give output as expected :
=TEXT(D1,"dd")&MID("stndrdthstndrdthst",MATCH(DAY(D1),{1,2,3,4,21,22,23,24,31},1),2)&" "&TEXT(D1,"mmmm yyyy")
Regards,
Paresh J
tony valko shows how to do this with conditional formatting
here
http://www.excelforum.com/tips-and-t...-or-later.html
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Pareshj, there are a couple of bugs in your formula. It should read:
Formula:Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi,
Yes, I just figured out that, but formula posted in previous reply is working fine.
It is. It's just when you switched the order round that it went a bit odd. A good piece of work, though!
=TEXT(A1,"ddd d") & ...
Entia non sunt multiplicanda sine necessitate
Shg... I didn't know you could do that!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks