PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes numbers cannot appear until 15 digit if ended with '0'

Reply

numbers cannot appear until 15 digit if ended with '0'
 
Thread Tools Rate Thread
Old 07-04-2006, 06:38 AM   #1
=?Utf-8?B?U3Vl?=
Guest
 
Posts: n/a
Default numbers cannot appear until 15 digit if ended with '0'


my computer cannot enter numbers until 15 digit (in Excel) if the number
ended with 0 exp; 28000.00 it appear 280. It is also cannot automatically
change to the format in currency eventhough I have changed the Format.
  Reply With Quote
Old 07-04-2006, 10:47 AM   #2
garfield-n-odie [MVP]
Guest
 
Posts: n/a
Default Re: numbers cannot appear until 15 digit if ended with '0'
In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.

Sue wrote:

> my computer cannot enter numbers until 15 digit (in Excel) if the number
> ended with 0 exp; 28000.00 it appear 280. It is also cannot automatically
> change to the format in currency eventhough I have changed the Format.
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off