I used the function arguments dialog to create and verify the function
results in a cell. When I select the OK button, the cell content displays
the formula not the results. I cannot seem to locate why.
Can anyone tell me why?
I used the function arguments dialog to create and verify the function
results in a cell. When I select the OK button, the cell content displays
the formula not the results. I cannot seem to locate why.
Can anyone tell me why?
The cell is probably formatted as Text, format it as General then click in
the formula in the formula bar and hit F2,
Regards,
Alan.
"Wally" <Wally@discussions.microsoft.com> wrote in message
news:074AA3FE-24A2-4440-86B5-8F3E2689B820@microsoft.com...
>I used the function arguments dialog to create and verify the function
> results in a cell. When I select the OK button, the cell content displays
> the formula not the results. I cannot seem to locate why.
>
> Can anyone tell me why?
Hi Wally,
If the cell is already formatted as General or a number and F2 fixes
it then you probably have spaces or Char(160). You could Trim the content of
text cells using the TrimALL macro in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Also check to make sure that you have calculation set to automatic.
Tools, Options, calculation (tab), calculation: automatic
When you change the format from text to number or number to text
the number format will not change until you reenter data. The TrimALL
macro will make this a lot easier for redoing large areas of cells
rather than using F2 then Enter for an individual cell.
Use of F2 then Enter will reenter data just the same as if you had typed in
new content. If F2 then Enter works it may serve also serve as
warning that calculation is not turned on.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Alan" <alan111@ntlworld.com> wrote in message news:%23eJ$kIetFHA.3188@TK2MSFTNGP14.phx.gbl...
> The cell is probably formatted as Text, format it as General then click in
> the formula in the formula bar and hit F2,
> Regards,
> Alan.
> "Wally" <Wally@discussions.microsoft.com> wrote in message
> news:074AA3FE-24A2-4440-86B5-8F3E2689B820@microsoft.com...
> >I used the function arguments dialog to create and verify the function
> > results in a cell. When I select the OK button, the cell content displays
> > the formula not the results. I cannot seem to locate why.
> >
> > Can anyone tell me why?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks