Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forcing caps lock
I have to setup a spreadsheet but i want to have all the data in the same format. Once they complete the data entry sheet the data is displayed on another spreadsheet. I would like to make everything on this sheet in capitals letters. whether it is typed in caps or not. Can it be done in either the entry sheet that it makes it caps or in the formula transfering the data thanks ps - some cells are text and numbers if that makes a difference. -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=546928 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forcing caps lock
Worked This Out =upper() -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=546928 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does caps lock automatically turn on? | Excel Discussion (Misc queries) | |||
Reverse Caps Lock | Excel Discussion (Misc queries) | |||
Pressing CAPS LOCK show me Activity Panel | Excel Discussion (Misc queries) | |||
How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
excel sheet all caps and needs to be only the first letter caps.. | Excel Discussion (Misc queries) |