Forum Discussion

Copper Contributor

Mar 11, 2020

Beginner at Formulas... need help

I need to take the total from column Adlts (column E) and multiply that number by 25, putting the sum in column Ex25 (Column F). Column E are the number of adults that have to pay for a dinner (Colum...

excel

Formulas and Functions

johne1650

Copper Contributor

Mar 12, 2020

mathetes

John. I have done something stupid.

Now when I type in =B45-C12, instead of getting a number, I get =B45-C12. What have I done?

Savia

Iron Contributor

Mar 12, 2020

johne1650 You have probably formatted that cell as Text, which overrides your ability to write formulas. Change it to General or another format and then re-enter the formula. If that still doesn't work, try Find & Replace = with = to kick Excel into noticing the change.