Display Formula Values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SJT (SJT_at_discussions.microsoft.com)
Date: 08/28/04 

Date: Sat, 28 Aug 2004 10:49:10 -0700

I have a number of formulas that are displaying the result using the value
that is displayed in a referenced cell rather than what was actually input.
For example, if my formula in cell A1 is B1*C1 and my value in C1 is .075 and
the cell is formatted to display a percentage with no decimal places my
formula in B1 uses 8% instead of 7.5%. How can I address this across the
entire workbook rather than having to change the format in each of the
necessary cells. Thanks for your help.

Relevant Pages

  • Re: To display number in text format in cells
    ... displaying *all* the digits. ... if you paste a number from a range onto a cell that is ... Format to TEXT *before* entering the number. ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.newusers)
  • Re: Why is the formula displaying rather than the actual value?
    ... Kind regards, ... > When I open the format cells dialog (checking that the general format> is ... > applied to the formula cell), the 'sample' area displays the value ... >> formula is still displaying rather than the value (which is displaying ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Date Format Issue
    ... "Mikeice" wrote: ... > I have the following code that enters the date when a cell is filled. ... > My problem is since it changed to June yesterday the date is displaying ... > in US date format. ...
    (microsoft.public.excel.programming)
  • Re: Changing a cells number format
    ... After further trouble-shooting I found another macro ... the cells are displaying the ... > isolate the problem and still I cannot get the cell format to change. ...
    (microsoft.public.excel.programming)
  • Date Format Issue
    ... I have the following code that enters the date when a cell is filled. ... IT works perfectly thx to this forums help - thx all. ... My problem is since it changed to June yesterday the date is displaying ... British / Australian format ...
    (microsoft.public.excel.programming)