close

This just began happening: in either a new or old spreadsheet when I enter a
number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
format to number, general, etc. the same result occurs. Any suggestions?

Thanks.

Tools/Options...under the Edit tab uncheck quot;Fixed decimalquot;

Regards
Jean-Guy

quot;justonebidquot; wrote:

gt; This just began happening: in either a new or old spreadsheet when I enter a
gt; number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
gt; 200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
gt; format to number, general, etc. the same result occurs. Any suggestions?
gt;
gt; Thanks.

Thanks!!! It worked. I'm still not sure why this began to happen, but glad
it stopped.

quot;pinmasterquot; wrote:

gt; Tools/Options...under the Edit tab uncheck quot;Fixed decimalquot;
gt;
gt; Regards
gt; Jean-Guy
gt;
gt; quot;justonebidquot; wrote:
gt;
gt; gt; This just began happening: in either a new or old spreadsheet when I enter a
gt; gt; number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
gt; gt; 200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
gt; gt; format to number, general, etc. the same result occurs. Any suggestions?
gt; gt;
gt; gt; Thanks.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()