Default cell format in Excel

G

Guest

Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format
shows as General. This happens on every new and existing workbook on a
particular PC. Could there be a setting somewhere or is it a fault in the
program?
 
R

RagDyeR

Correct the setting at:

<Tools> <Options> <Edit> tab,
And *Uncheck*
"Fixed Decimal Places".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format
shows as General. This happens on every new and existing workbook on a
particular PC. Could there be a setting somewhere or is it a fault in the
program?
 

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
Default Cell Format Changed? 5
Set default cell format while retaining overrides 3
Default Cell format of existing Worksheets got changed automatical 1
Default cell format has reverted to Time 8
Default number format in Excel 1
CELL FORMAT 5
Peculiar default cell format 1

Top