a) click on a cell and look in the formula bar - do you see a formula?
b) CTRL+~ (the key next to 1 on top row of 'normal' keys) will toggle
display formulas on/off
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"TechNoFear" wrote
in message ...

Hi,

I am trying to see a formula and display formulas isn't doing it for
me

the column changes from
04:40
04:40
04:50
04:40
04:30
04:50
04:50
06:20
04:50
04:50

to

0.194444444444444
0.194444444444444
0.201388888888889
0.194444444444444
0.1875
0.201388888888889
0.201388888888889
0.263888888888889
0.201388888888889
0.201388888888889

which isn't what I expected

the spreadsheet isn't protected and I expected something like

if value constant then red else green


could someone tell me how to display formulas in this spreadsheet
please?



tia,


--
TechNoFear
------------------------------------------------------------------------
TechNoFear's Profile:
http://www.excelforum.com/member.php...o&userid=35622
View this thread: http://www.excelforum.com/showthread...hreadid=554009