| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas not working in Microsoft Excel 2007 table
I often have to adjust my formulas, which are huge!, in my tables. When I
change a formula the formula stays visible and does not do any calculations. Sometimes I force the formula to work when I convert the column with the "text to columns" tool, but it hasnt' worked for me today. HELP!! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas not working in Microsoft Excel 2007 table
Press Cntrl+Tilde (~) Button. The Tilde button (~) will be available above
the left tab button. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "tracyprev" wrote: I often have to adjust my formulas, which are huge!, in my tables. When I change a formula the formula stays visible and does not do any calculations. Sometimes I force the formula to work when I convert the column with the "text to columns" tool, but it hasnt' worked for me today. HELP!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet | Excel Discussion (Misc queries) | |||
| Pivot Table column total not working (Excel 2007) | Excel Worksheet Functions | |||
| Paste Special Multiply Formulas not working in Excel 2007 | Excel Worksheet Functions | |||
| Viewing formulas for Print in Microsoft Office 2007 | Excel Worksheet Functions | |||
| Working Excel 2007 pivot table, want just text to show on the pivo | Excel Discussion (Misc queries) | |||
Linear Mode
