| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel text formula does not calculate after editing
It sounds like the cell is formatted as TEXT. Format the cell as General
then either type the formula or, if it's already in the cell, select the cell and hit function key F2 then hit ENTER. -- Biff Microsoft Excel MVP "lannyk" wrote in message ... I have a simple formula =A16&","&TEXT(ROUND(e16,2),"0.00") and it works very well and I've used that and variations extensively. If I copy to another cell it works well. Now however when I try to type the formula into a cell or edit it after I've copied it all I get is the formula displayed - not the result. Help, LK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does editing a formula cause cell to reformat to text? | Excel Discussion (Misc queries) | |||
| Editing Text | Excel Discussion (Misc queries) | |||
| vlookup formula editing based on numbers treated as text | Excel Worksheet Functions | |||
| Editing an excel spreadsheet with the new data in colored text? | Excel Discussion (Misc queries) | |||
| calculate a formula instead of returning text | Excel Worksheet Functions | |||
Threaded Mode
