Forum Discussion
jjkuest
Jun 01, 2023Copper Contributor
Excel is converting my formulas into values
I am using Excel through my Microsoft 365 account (Version 2303, 32-bit). Every time that I type a formula in a cell, like "=LEN(A2)", Excel will convert it to the value. If I insert a new sheet into...
HansVogelaar
Jun 01, 2023MVP
Right-click the sheet tab of the problem sheet and select 'View Code' from the context menu.
Is there code in the worksheet module?
jjkuest
Jun 02, 2023Copper Contributor
HansVogelaar Yes, I just found my problem. Thank you. UCASE was converting my formula to a value.