My formulas return the formula not a result in the cell
Try this:
First, make sure B1 is not formatted as Text.
Select B1, then FormatCellsNumber Tab
(Category should NOT be Text)
If the format is OK, then:
Select B1
DataText-to-ColumnsClick the [Finish] button
Does that fix the problem?
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"1stcoast" wrote:
Cell A1
Formula in cell B1
00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)
The calculation returns the formula not a result. What am I doing wrong?
|