66 years old.

I have been asked to record daily my weight and blood-sugar count. I am
using Excel 2003 on a Vista machine. I am trying to compare averages between
doctor visits.

I have both columns formatted as number
(select columnformatcellsnumber, 2dp)
yet when I try to sum or average the numbers, the formula only includes the
last 3 cells. It also will not add the .00 to the rest of the numbers in the
columns. I have selected the entire spreadsheet and made sure the protection
"lock" is not selected.

I hope I explain myself well enough for someone to help - I am certainly no
whiz at this. Thanks in advance for all help.