Text to general

[ngs007]

Hi
I have a load of cells that are linked. It appears many are linked to cells that are formatted as text (I was unaware of this). As a result the linked cell shows the formula rather than the value of that linked cell. So far the only way I have been able to correct this is by highlighting linked cell, select format and choose general format. Then though I have to double click in the actual cell and press enter for it to change to the linked value.
Is there an easier/quicker way of getting the values showing in the linked cells rather than the formulas?
Thanks

[Special-K]

Does F9 Recalculate not work?

[:) Sixthsense :)]

Also Posted in

http://www.excelforum.com/excel-gene...o-general.html

[tuph]

After formatting the cells as general, select those cells, click on the Data ribbon, select Text to Columns, select Fixed Width, click Finish. This works for me.

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-gene...o-general.html