Function Errors

[Guest]

Howdy

For most of the sheets in a spreadsheet document - I can set a cell equal to: ='Point Sheet'!C7 and the cell will display the value from C7 on the 'Point Sheet' page

However, I have a couple cells that display the formula instead of the value of the cell on a different sheet

Hel

suggestions??

Danie
(e-mail address removed)

 

[Frank Kabel]

Hi Daniel
probably the cells are formated as 'Text'. Try the following:
- select the cell
- goto 'Format - Cells' and format the cells as 'General'
- re-e´nter your formula (or just simply click F2 and hit ENTER)

--
Regards
Frank Kabel
Frankfurt, Germany

Howdy,

For most of the sheets in a spreadsheet document - I can set a cell

equal to: ='Point Sheet'!C7 and the cell will display the value from C7
on the 'Point Sheet' page.

However, I have a couple cells that display the formula instead of

the value of the cell on a different sheet.

 

[Mark]

This is a long shot, but when Formula Auditing is on the formula are shown
rather than the results. It is switched on and off using Tools/Formula
Auditing/Formula Auditing Mode

Mark

Howdy,

For most of the sheets in a spreadsheet document - I can set a cell equal

to: ='Point Sheet'!C7 and the cell will display the value from C7 on the
'Point Sheet' page.

However, I have a couple cells that display the formula instead of the

value of the cell on a different sheet.