How to Enter and Format Dates in Excel

[jimbij007]

Danny, Is there any short cut keys in excel which would change lower to uppercase and vice versa in excel just as in ms word?..

[DannyRocksExcels]

@jimbij007

Thanks for asking me.

While there is not a keyboard shortcut for converting text cases in Excel, there are TEXT Functions that you can use:

1) The UPPER() Function converts all text in a cell to UPPER CASE.

2) The LOWER() Function converts all text in a cell to lower case

3) The PROPER() Function converts all text in a cell to Proper Case

Danny Rocks

The Company Rocks

[jimbij007]

@DannyRocksExcels Thanks for the info..

[DannyRocksExcels]

@jimbij007

My pleasure! I try my best to get answers back as quickly as I can.

Danny Rocks

The Company Rocks

[jimbij007]

Your videos are really great.. Just started watching.

[DannyRocksExcels]

@jimbij007

Thank you for your kind words. I am pleased that you are enjoying my video tutorials!

Danny Rocks

The Company Rocks

[scoogarf]

Just what I was searching for, thank you!

[DannyRocksExcels]

@scoogarf

Great. I am pleased that I was able to give you the information that you needed.

Danny Rocks

The Company Rocks