| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula appears as text
I am entering numbers in a spreadsheet but when I try and sum them the
destination cell shows the formula as text eg =+E1+E2+E3 instead of the value. I have formatted the cells as numbers |
|
#2
|
|||
|
|||
|
Hi
check tools / options / view and ensure that formulas is unchecked. in addition, if you changed the cell from text to number this may not be enough to reset it choose your worksheet, do edit replace and replace an = with an = (you might want to do this on a back up of your workbook first) Cheers JulieD "Tiles" wrote in message ... I am entering numbers in a spreadsheet but when I try and sum them the destination cell shows the formula as text eg =+E1+E2+E3 instead of the value. I have formatted the cells as numbers |
|
#3
|
|||
|
|||
|
Thanks, JulieD. Formulas was checked. Unchecking solved the problem.
Cheers Tiles "JulieD" wrote: Hi check tools / options / view and ensure that formulas is unchecked. in addition, if you changed the cell from text to number this may not be enough to reset it choose your worksheet, do edit replace and replace an = with an = (you might want to do this on a back up of your workbook first) Cheers JulieD "Tiles" wrote in message ... I am entering numbers in a spreadsheet but when I try and sum them the destination cell shows the formula as text eg =+E1+E2+E3 instead of the value. I have formatted the cells as numbers |
|
#4
|
|||
|
|||
|
you're welcome and thanks for the feedback
"Tiles" wrote in message ... Thanks, JulieD. Formulas was checked. Unchecking solved the problem. Cheers Tiles "JulieD" wrote: Hi check tools / options / view and ensure that formulas is unchecked. in addition, if you changed the cell from text to number this may not be enough to reset it choose your worksheet, do edit replace and replace an = with an = (you might want to do this on a back up of your workbook first) Cheers JulieD "Tiles" wrote in message ... I am entering numbers in a spreadsheet but when I try and sum them the destination cell shows the formula as text eg =+E1+E2+E3 instead of the value. I have formatted the cells as numbers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in cell as Formula | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
| Wrapped text appears as xxxxxx | Excel Discussion (Misc queries) | |||
Linear Mode
