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
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