From: Ms-Exl-Learner on 28 Jan 2010 21:58 Yes David sir I missed to read the word "Certain Column", after reading your reply I come to know that I have missed something to read or I read and understood it wrongly. Once Thanks for your Guidance!!! -------------------- (Ms-Exl-Learner) -------------------- "David Biddulph" wrote: > That would work if it were all the formulae on the sheet which were being > displayed as formulae, but the wording of the OP suggested that the problem > was confined to one cell or one column, in which case it would sound more > likely to be due to the cell being formatted as text. > -- > David Biddulph > > "Ms-Exl-Learner" <Ms.Exl.Learner(a)gmail.com> wrote in message > news:F9A92802-5112-46C2-9525-68F2FD024F3E(a)microsoft.com... > > Try this. > > > > Press CNTRL + TILDE key, whch is available above the Tab Key. > > > > Remember to Click Yes, if this post helps! > > > > -------------------- > > (Ms-Exl-Learner) > > -------------------- > > > > > > "nv77078" wrote: > > > >> Everytime I visit a cell with a formula in a certain column of my > >> worksheet > >> and press enter, that cell will only show the formula instead of the > >> result. > >> Any idea on how to show the result back again for those cells? > >> Nancy > > > . > |