| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering the same text into multiple cells on multiple worsheets
That means you have the cells format set to text. So no matter what
you put in the cell it will think it is just supposed to be text. Change the format of the cells to text. Then to get it to recalculate the formula do a find and replace on the whole worksheet for = and then replace it with =. Does anyone out there know a better way to force calculation (other than F9) then this find and replace trick? I have heard of a short cut key something like ctrl + alt + F9 or something. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
| How to avoid duplicates across multiple worsheets in excel? | Excel Discussion (Misc queries) | |||
| Entering same data into multiple cells | Excel Discussion (Misc queries) | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
| Multiple worsheets | Excel Programming | |||
Hybrid Mode
