XL Appends Four Zeros to All Integers. Help?

L

Lucky25

Hi All!

OS: Windows XP
SW: Excel 2002, SP-1

Whenever I enter in an integer in any given cell for ANY
workbook (new or existing), XL adds four zeros to the end
of it, EXCEPT when the cell has been formatted as
a "text" cell.

Question = How do I keep Excel from doing this?


<!-- Start Example -->

Cell A1 = Any format except for "text"
Cell A2 = "Text" formatted cell


I type '1' into A1
==> XL returns '10000' (General, Number, Currency, etc)
==> XL returns '1.0+e4' (Scientific)

I type '1.0' into A1
==> XL returns '1'


I type '1' into A2
==> XL returns '1'

<-- End Example --!>

Any feedback/suggestions/questions, please reply to the
thread, so that all can benefit from this.

Thank you in advance for your help!!!

Lucky25
 
G

Gord Dibben

Lucky

Try Tools>Options>Edit. You may have "Fixed decimal places" checked and set
at -4

Uncheck it.

Gord Dibben Excel MVP
 
L

Lucky25

Wow, that was a really simple fix. That was the exact
source of the problem. Strange though, as I haven't been
in Options for a few months... oh well, it's fixed, and I
learned something new.

Thank you, Gord!
Lucky25
 
G

Gord Dibben

Simple is what we like.

Gord


Wow, that was a really simple fix. That was the exact
source of the problem. Strange though, as I haven't been
in Options for a few months... oh well, it's fixed, and I
learned something new.

Thank you, Gord!
Lucky25
Click to expand...
 
Top