Excel 2000 Cell Format Problem

B

Bill Helbron

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 Format>Cells>Number
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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Format 1
Peculiar default cell format 1
Excel date format YYYYMMDD 1
CELL FORMAT 5
incorrect number format 2
negative number format 1
formula cell format change 3
Column with currency & text - how to format? 2

Top