Make all text ALL Caps in Excel - Microsoft: Office | Tek-Tips
Feb 2, 2005 · Hello I am trying to capitalize all text in one specific column. I am unable to find the button or command to make all lowercase text ALL CAPS. Can anyone...
Making Excel respond to keystokes using VBA | Tek-Tips
Jul 16, 2002 · I am trying to save a file in excel using the SaveAs function, due to the need of making the file an Excel 5/95 & 97 compatible. Everything works fine, however when the …
Small Caps Font in Excel | Tek-Tips
Feb 25, 2003 · There is a small caps font in Word which will make your first letter a larger cap then the rest of your upper cap text. Is there any way to get this font in Excel? Seems that if …
How to: change entire Excel spreadsheet to all Caps | Tek-Tips
Feb 1, 2001 · Hi all, I have a 10 page Word document with embedded excel sheets and the client has decided that they want it all in capitals now. How would I go about converting all letters to …
Change format date, dd-mmm-yyyy, but month i need to be in
Jun 11, 2002 · I'm doimg a macro , in a range of cells i need to convert the format of the cell, the format taht i want is Date: dd-mmm-yyyy but my problem is i can't convert the month in font …
Scanner LS2208 Upper Case | Tek-Tips
May 18, 2012 · I have a number of LS2208 Symbol Scanners that change the case of the alphabet characters when Caps Lock is turned on. The bar code has an alphanumeric code of …
I can't add sheets to my Excel file because it's protected.
Oct 11, 2005 · Somehow while protecting individual sheets I have somehow locked the entire workbook. Stupid question. How do I remove it? I likely did it accidentally but if I entered a …
Forcing Caps Lock On | Tek-Tips
Apr 16, 2001 · Is there any way to use code to turn caps lock on if it is not already on? I am trying to keep consistency in the data entered in the database. I need it to be entered in all caps and …
force text to all CAPS - Microsoft: Access Queries and JET SQL
Jun 27, 2025 · In a select statement, can I force the results to ALL CAPS. I will be exporting the data and need it in this format.
Converting a text string to all caps | Tek-Tips
Aug 5, 2003 · I'm looking for an SQL solution to put the text of one columns in all caps, i.e. "Text" becomes "TEXT". I had expected results with the UPPER command as follows: UPDATE …