Excel 2k refuses to quote my weight properly!!!! 1

[Sparent]

Each time I enter my weight in one of the columns of my "training spreadsheet", MS Excel turns my weight to decimals!!

I.E.: I entered 198lbs today and this thing argues with me that i am 1.98lbs! I went to Format cell.../Number tab/ and tried many different Categories but to no avail, i still weight 1.98lbs.

How do I prove him wrong?

Simon

 

[MisterC]

Tools | Options | Edit
Uncheck Fixed Decimal Places


Good Luck!

 

[Sparent]

Will try that later today and let you know.

Thanks for the help,

Simon

 

[Sparent]

Of course you were right MisterC, Thank you very much.

Simon

 

[MisterC]

You're welcome, glad to help!