In xl2003 menus:
Tools|Options|Edit tab
Uncheck fixed decimal places

It's nice for accounting types. Not so nice for the rest of us.

Bill Helbron wrote:

I just went to enter new some new data and noticed that when I expanded my
date column, began entering the new data in the next column, the format
changed from, e.g. "87" to "0.87". I tried changing the FormatCellsNumber
to "General" and the result appears as "0.87". Likewise, "General" appears
as "0.87", "Currency" appears as "$.087", etc. What's happened here? Thanks!

Bill

--

Dave Peterson