Troubleshoot a bug in Excel

D

d_a_v_e_s

I am just begining to use Excel spreadsheets after using Lotus 1-2-3
spreadsheets for several years. Whenever I enter a number in a cell.
Excel adds a decimal point, even if the number format I use doesn't
include a decimal point. It just doesn't look right to have an interger
number like 5280 displayed as 5280.(with decimal point) Is this a bug
in Excel? How can I fix this problem?
 
R

Ron Rosenfeld

I am just begining to use Excel spreadsheets after using Lotus 1-2-3
spreadsheets for several years. Whenever I enter a number in a cell.
Excel adds a decimal point, even if the number format I use doesn't
include a decimal point. It just doesn't look right to have an interger
number like 5280 displayed as 5280.(with decimal point) Is this a bug
in Excel? How can I fix this problem?

Hmm, I can't reproduce this problem in XL2002 under Windows XP Pro. Even if I
type in 23.0, with Number Format and 0 decimal places (or General format), I do
not see a decimal point displayed. (Unless I enter it as TEXT).

What version?

What, exactly, is the cell format?

Did you set it before or after you entered the number?

What are your regional/language options (under Control Panel).

I'm looking for clues; but maybe someone else has run across this before.
--ron
 

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

Top