Formula result disappeared
in [General]
|
From: nv77078 on 26 Jan 2010 11:39 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
From: "David Biddulph" groups [at] on 26 Jan 2010 11:53 The cell is presumably formatted as text. Format as General (or Number) and re-enter the formula. -- David Biddulph "nv77078" <nv77078(a)discussions.microsoft.com> wrote in message news:0C07E90A-7AFE-4288-9673-31E602C3AF5B(a)microsoft.com... > 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
From: Ms-Exl-Learner on 26 Jan 2010 11:56 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
From: "David Biddulph" groups [at] on 26 Jan 2010 12:08 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
From: nv77078 on 26 Jan 2010 14:17
This worked, thank you! "David Biddulph" wrote: > The cell is presumably formatted as text. Format as General (or Number) and > re-enter the formula. > -- > David Biddulph > > "nv77078" <nv77078(a)discussions.microsoft.com> wrote in message > news:0C07E90A-7AFE-4288-9673-31E602C3AF5B(a)microsoft.com... > > 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 > > > . > |