Friday, April 18, 2008 – Permalink –
Excuse Me Your Formula's Showing
Try this experiment. On a sample worksheet, enter some arbitrary data in say the A1:B5 range.
Select the C column and format it as Text.
(Right click choose Format Cells - on the Number tab choose Text)
In cell C1 enter a function, such as =sum(a1:b1)
With C1 still selected, double click the Fill handle
(the tiny box at the lower right corner of the cell.)
Now reformat the column as Text. The formulas still work, but if you edit one of them, it reverts to a text display.
<Doug Klippert@ 7:31 AM
Comments: Post a Comment