Re: Formulas not calculating

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Then I don't know what else to suggest. What you describe can't be
attributed to anything other than corruption & that's the normal way to
clear it up.

Just keep in mind that if the cells with the problem were formatted as text
while or before the formula was typed in -- or if the formula was pasted as
text -- just changing the format of the cell back to General [or anything
else] will not revive the formula. Have you tried retyping the formula
*after* changing the cell format to General?

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 5/14/09 9:16 AM, in article C631D84F.10849%roddie@xxxxxxxxxxxx, "Roddie
Grant" <roddie@xxxxxxxxxxxx> wrote:

Hi Bob

Copy and paste doesn't make any difference. The new sheet has the same
problem.

There haven't been any other anomalies.

Regards

Roddie


On 11/5/09 17:39, in article OmAIubl0JHA.5924@xxxxxxxxxxxxxxxxxxxx,
"CyberTaz" <gtz1@comcastdotnet> wrote:

Hi Roddie;

Despite macropod's best of intentions neither version of Mac Office has a
Detect & Repair facility.

What happens if you select the content of the entire sheet then copy & paste
into a new workbook?

Are there any other anomalies you've noticed?


.

Relevant Pages

  • Re: Copy current color of conditional formatted cell
    ... format applied if True for each cell. ... Following assumes you know the all CF's on the source sheet are like this ... Dim cnt As Long, i As Long ...
    (microsoft.public.excel.programming)
  • Re: A fast way to fill cells in Excel
    ... is to find a fast way for formating cells with color and Border without each ... time getting the Interior and the Border of the cell (as I saw this is time ... per sheet, one after another). ... Copy method I'm modifying the format of all my other "ranges" (which allways ...
    (microsoft.public.excel.programming)
  • Re: Excel2000: A problem with Named Range/Function format
    ... Week numbers on WorkingTime sheet are entered through VBA. ... format for cells ot of used range is general. ... After that cell formats from previous ... When I format the cell before, the same entry is behaving as text ...
    (microsoft.public.excel.misc)
  • Re: Copy values from multiple sheets
    ... Assume Bridge is the sheet with the list of sheet names ... Add the code to set your format if appropriate ... Dim rng As Range, cell As Range ... Dim jRow As Long ...
    (microsoft.public.excel.programming)
  • Re: Conditional format oddity in Excel 2007
    ... cells turn to yellow background if I add a number 1 to the cell ... On the same sheet, I have a conditional format for the column headers, ... such that the cell should change colour if the result of a sum is 11 ...
    (microsoft.public.excel.worksheet.functions)