ExcelBanter - Excel 2000 Cell Format Problem

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Excel 2000 Cell Format Problem (https://www.excelbanter.com/setting-up-configuration-excel/230044-excel-2000-cell-format-problem.html)

Excel 2000 Cell Format Problem

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

Excel 2000 Cell Format Problem

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