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

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

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 helpfulRegards

Myburgh

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History