Formula shiw in cell not value

Microsoft Excel 2007
February 12, 2010 at 05:28:16
Specs: Windows XP
Hi
I have a constant problem in some cells in a worksheet. The formula in A1 is =Data!C5. This has to pick op a value in DataC5 and show it in NameA1 The value does not return and only the formula. If I do this in other cells the formula =DATA!C5 works fine and return the value.

Thanks for the help

Myburgh


See More: Formula shiw in cell not value

Report •


#1
February 12, 2010 at 05:50:45
Hi,

This is probably because A1 was formatted as text at some time, and despite entering a formula it keeps on treating it as text.

Try this:
Delete the formula.
Right click and format the cell with a number format.
Enter a number in the cell.
Now enter your formula again.

Regards


Report •

#2
February 12, 2010 at 06:22:57
Humar
Thanks apprecciate the quick reply.

I formatted the cell to general, pressed F2 and enter and al was well again

Thank you for your time and effort
Your suggestion was very helpful

Regards

Myburgh


Report •

Related Solutions


Ask Question