![]() |
why will my function not work? it is just auto sum.
All I am trying to do is use auto sum. Why does it just show the actual
function and not the answer? Thanks. |
why will my function not work? it is just auto sum.
The cell must be currently formatted as text, select Format - Cells and
choose General. Then, click on your cell and hit F2 and hit enter to refresh the formula -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Mary needs help" wrote: All I am trying to do is use auto sum. Why does it just show the actual function and not the answer? Thanks. |
why will my function not work? it is just auto sum.
Your cell was probably formatted as text before you entered the formula.
Format the cell as General, then go into the formula bar and confirm the formula again. -- David Biddulph "Mary needs help" <Mary needs help @discussions.microsoft.com wrote in message ... All I am trying to do is use auto sum. Why does it just show the actual function and not the answer? Thanks. |
All times are GMT +1. The time now is 07:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com