| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel text formula does not calculate after editing
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
