Ever Present Decimal

B

barnesy

I am transitioning from Lotus 1-2-3 to Excel. In Excel whenever I ente
a number in a cell it auomatically adds a decimal point at the end o
the number. Even when I set the decimal selection at 0 in the cel
formatting, the decimal point stays there. All the formulas work fine
but it looks pretty silly for 1234. to be the way a whole number t
appears
 
E

Earl Kiosterud

Barnesy,

The way numbers are presented are controlled by Format - Cells - Number.
Normally, they're set to General. I suspect yours are something other.
 
D

David McRitchie

Tools, Options, Edit (tab),
remove the checkmark next to Fixed Decimals ... places.


Earl Kiosterud said:
Barnesy,

The way numbers are presented are controlled by Format - Cells - Number.
Normally, they're set to General. I suspect yours are something other.
Click to expand...
 

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

Access stripping decimal places in query 1
Troubleshoot a bug in Excel 1
Formula to identify decimal versus whole numbers 12
how to add decimal to beginning of imported number 2
Decimal Numbers typed into Excel 2003 read as whole numbers 1
Cell Text Alignment - Not A Centering Issue 4
Show decimal point only if not a whole number 2
Lotus to Excel Problem 2

Top