My formulas will not calculate

A

AnneFromBVMktg

I am trying to use the PROPER formula to correct the case of names in a data
base.
The formula will not calculate. I have set the Calculation button in tools
options to automatic. I have also tried the CTRL+` step. This happens whether
the cells are formatted to be locked, unlocked, hidden or not.
 
G

Gary''s Student

Make sure your font supports both upper and lower case characters. Some
fonts do not.
 
G

Glenn

AnneFromBVMktg said:
I am trying to use the PROPER formula to correct the case of names in a data
base.
The formula will not calculate. I have set the Calculation button in tools
options to automatic. I have also tried the CTRL+` step. This happens whether
the cells are formatted to be locked, unlocked, hidden or not.
Click to expand...

Might be helpful to see a sample of your data and your formula that isn't working.
 
A

AnneFromBVMktg

I found it! Turns out the cells must be formatted as General rather than
Text. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Drop down list control value in vba 2
Excel formula help for calculating freight. 2
Tiered Pricing Formulae - is this possible? 4
Consolidation Table from Different Excel Tabs with Different Format 1
Formula displaying don't know why 1
Enable Iterative Calculations 0
Formula for calculating target hours against actual hours 12

Top