(Msg. 1) Posted: Wed Aug 06, 2008 7:39 pm
Post subject: Problem with formula showing in cell Add to elertz Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I am having a problem with a excel document that I exported from a pdf file.
When I enter a formula in a cell the cell shows the formula continously. I
know that something happened like this a few years ago and there was an
adjustment that could be made in calculation and it would be fixed but that
doesn't seem to be working in this instance. Any suggestions?
(Msg. 2) Posted: Wed Aug 06, 2008 8:33 pm
Post subject: Re: Problem with formula showing in cell Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The cells are formatted as Text.
Format all cells to General then re-enter the formula by F2 + ENTER.
Gord Dibben MS Excel MVP
On Wed, 6 Aug 2008 19:39:01 -0700, andyK <andyK DeleteThis @discussions.microsoft.com>
wrote:
>I am having a problem with a excel document that I exported from a pdf file.
>When I enter a formula in a cell the cell shows the formula continously. I
>know that something happened like this a few years ago and there was an
>adjustment that could be made in calculation and it would be fixed but that
>doesn't seem to be working in this instance. Any suggestions?
(Msg. 3) Posted: Thu Aug 07, 2008 4:48 pm
Post subject: Re: Problem with formula showing in cell Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks so much. Big help.
Andy
"Gord Dibben" wrote:
> The cells are formatted as Text.
>
> Format all cells to General then re-enter the formula by F2 + ENTER.
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Wed, 6 Aug 2008 19:39:01 -0700, andyK <andyK RemoveThis @discussions.microsoft.com>
> wrote:
>
> >I am having a problem with a excel document that I exported from a pdf file.
> >When I enter a formula in a cell the cell shows the formula continously. I
> >know that something happened like this a few years ago and there was an
> >adjustment that could be made in calculation and it would be fixed but that
> >doesn't seem to be working in this instance. Any suggestions?
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office