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.
- May 27 Tue 2008 20:44
incorrect number format
close
全站熱搜
留言列表
發表留言
留言列表

