LinkBack URL
About LinkBacks
I'm using dddd dd/mm-yy
But the day starts with a small letter, how do I capitalize this?
I'm using dddd dd/mm-yy
But the day starts with a small letter, how do I capitalize this?
change to
Dddd dd/mm-yy
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That's doesn't change it.
Mine is capitalised - but notice the DDDD or dddd makes no difference
check the proofing options
http://excelribbon.tips.net/T009698_...Day_Names.html
It can be done with formula
Formula:
Please Login or Register to view this content.
v A B 1 3/6/2016 SUNDAY 06/03-16
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Instead of this: SUNDAYOriginally Posted by AlKey
I think they want this: Sunday
=PROPER(TEXT(A1,"dddd dd/mm-yy"))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
@Tony
It is proper by default. OP want's it capitalized
Hmmm, yes, I see that now!
You must be right!OP want's it capitalized
It's not proper. 1/7-16 as dddd dd/mm-yy returns "friday 1/7-16"
So does Dddd dd/mm-yy
I dont have any helper columns/cells to do a formula
lol@ just checked proofing - it says "Capitalize first letter in english days", that doesnt help much when I'm not using english :D
Last edited by horsefish01; 03-06-2016 at 02:31 PM.
you want
Friday 1/7-16
to be displayed
did you check the options as posted in #4
otherwise can you post a sample sheet
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
I did that. The problem is that Excel only autocorrects days if it's in english, which mine isn't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks