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

Excel does not accept text format! 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Excel Issue with "Average" showing in Status Bar 2
Macro to Format Multiple Sheets based on "Master" Format 0
Time Sum in Excel 1
Conditional formatting based on formula cell 4
For Joey2004 et al. From OP: Re Appending Question 3
Excel 2007 Slow Typing and Cell Change 3

Top