ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel type lower displays upper (https://www.excelbanter.com/excel-discussion-misc-queries/74443-excel-type-lower-displays-upper.html)

cindy

excel type lower displays upper
 
I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?

Ken Wright

excel type lower displays upper
 
Either disable the macro that is doing it, or turn off CAPS Lock perhaps?

When you open the file does it ask if you want to enable macros

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"cindy" wrote in message
...
I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?




cindy

excel type lower displays upper
 
Caps is not on and no macros.. strange to me

"Ken Wright" wrote:

Either disable the macro that is doing it, or turn off CAPS Lock perhaps?

When you open the file does it ask if you want to enable macros

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"cindy" wrote in message
...
I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?





Dave Peterson

excel type lower displays upper
 
What font are they using?

Maybe the font shows all caps--no matter what was typed in the cell???

What do you see in the formulabar?

cindy wrote:

Caps is not on and no macros.. strange to me

"Ken Wright" wrote:

Either disable the macro that is doing it, or turn off CAPS Lock perhaps?

When you open the file does it ask if you want to enable macros

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"cindy" wrote in message
...
I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?





--

Dave Peterson


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com