All I want to do is make the current date in capital in one cell, probably simple

**CHAT** · 02-13-2014, 11:41 AM

Helloo Everybody, First time here.
This is probably a very simple question but i just want to know how to make the current date formula into Capital letters. =today() February 13 2014 in that format

Help Please. I'm tired of searching the net

Chat

**daddylonglegs** · 02-13-2014, 11:43 AM

Try this formula

=UPPER(TEXT(TODAY(),"mmmm d yyyy"))

**Jonmo1** · 02-13-2014, 11:44 AM

Put =TODAY() in your cell.
Then format that cell as Custom: mmmm dd yyyy

**Tony Valko** · 02-13-2014, 11:45 AM

Maybe this...

=UPPER(TEXT(NOW(),"mmmm d yyyy"))

**CHAT** · 02-13-2014, 11:51 AM

OMG you guys are AWESOME

Thank you so much, I should have joined here a hour ago :-)

Chat

**Tony Valko** · 02-13-2014, 11:57 AM

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

**Jonmo1** · 02-13-2014, 12:00 PM

Originally Posted by CHAT

I should have joined here a hour ago :-)

Just an Hour?

lol, glad to help.

All I want to do is make the current date in capital in one cell, probably simple

LinkBack

Thread Tools

Rate This Thread

Display

All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Re: All I want to do is make the current date in capital in one cell, probably simple

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines

[SOLVED] Want a simple Macro to move a cell down from a current cell

Make selection from Data Validation list and post current date stamp in different cel

Make date change in excel to current date when opening daily?

[SOLVED] How to make drop-down list of dates start with current date?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions