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