general fromat goes to 4 place decimals

Numbers entered in the general format (not numbers format) 
go out to 4 place decimals even when entered with-out 
decimals. Any clue? Is it a system setting thing?
..


0
anonymous (74722)
12/13/2003 6:40:43 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
289 Views

Similar Articles

[PageSpeed] 3

They aren't also 10,000 times smaller than they should be are they??  OIf so,
then Tools / Options / Edit / Uncheck 'Fixed Decimals'

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



"Garr Fitz" <anonymous@discussions.microsoft.com> wrote in message
news:014601c3c1a8$9d82fe20$a101280a@phx.gbl...
> Numbers entered in the general format (not numbers format)
> go out to 4 place decimals even when entered with-out
> decimals. Any clue? Is it a system setting thing?
> .
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003


0
ken.wright (2489)
12/13/2003 7:30:04 PM
Please refrain from multi posting

-- 

Regards,

Peo Sjoblom

"Garr Fitz" <anonymous@discussions.microsoft.com> wrote in message
news:014601c3c1a8$9d82fe20$a101280a@phx.gbl...
> Numbers entered in the general format (not numbers format)
> go out to 4 place decimals even when entered with-out
> decimals. Any clue? Is it a system setting thing?
> .
>
>


0
terre081 (3244)
12/13/2003 9:08:30 PM
Reply:

Similar Artilces:

Exchange Delivery Delay (Error 4.4.7)
We recently installed SBS 2003 and are using Exchange 2003 for email. Everyone can log in and use exchange with no problems. All seems to be working ok. But some of the users are getting Non Delivery Reports. On some email messages. The reports are in the following formats: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. carlos.caxias@dywid.pt Reporting-MTA: dns;maildywid.Dywid.co.uk Final-Recipient: rfc822;carlos.caxias@dywid.pt Action: d...

Print Preview #4
I would like to preview my worksheets that contains coloured cells as they will print on a BW printer so I know what my charts etc. will actually look like. How do I turn off the Print Preview in colour when printing to a BW printer? i.e. I want to see exactly what will print depending on what printer I go to (the BW or the Colour). Further, I am not asking about the Page Setup option of checkmarking Black and White as that will print in only Black and White and not scale my colours and patterns accordingly to the % they would actually print. Please advise and thank you. Deborah ...

how do i create 4 pie charts
Hi, Could I enquire if someone could show me the steps to create 4 pie charts in diagram (1 pie chart representing one calendar year)? How do I modify the different size of the pie chart? Thanks a lot. Hi, A chart can only contain a single Pie chart so you will need to create 4 charts. If you create chartobjects these can be embedded in a worksheet or a blank chart sheet. To adjust the size you can alter the plot area. You don't mention what you are using to determine the size of the pie but this page may be of use. http://www.andypope.info/charts/piesizer.htm Cheers Andy Mik...

Printing Checks #4
Do I have to buy checks that already have my account and routing number printed to use Money 2003 Standard? Yes. "Tom P" <anonymous@discussions.microsoft.com> wrote in message news:06b601c3aef9$dc7264c0$a301280a@phx.gbl... > Do I have to buy checks that already have my account and > routing number printed to use Money 2003 Standard? ...

CRM 4.0 Private/Public Views
How do I make a view private in CRM 4.0? There are a bunch of system views that we do not use and that we obviously cannot delete. I used to just make them private in CRM 3.0, but I cannot figure out where to do that in 4.0. We also have a lot of views that are private because they are shared between sales teams and it seems like the "private" option has disappeared for 4.0. If it is gone, what would I do to hide certain views? In CRM 4 public views can not be hidden, these pages give a way it can be done. http://mscrmuk.blogspot.com/2008/08/hiding-system-views-in-crm-40...

CRM 4.0 Email Router Mailbox not deleting items
We are using the Email Router for Dynamics 4.0. An account and mailbox has been setup called CRM Mail. This accounts mailbox has grown to 9 Gig. Upon further inspection it looks like there are "forwards" of individuals emails in the Inbox of this account, that have been sent from our CRM Users. Do these messages need to remain in the Inbox or can we safely delete them? Are they supposed to be automatically deleted? Also, why are all these emails showing up? Thanks all! The emails in the forward mailbox should be deleted automatically after being processed by the router. ...

Money 2004(and higher)and Windows Mobile 2003 Second Edition 4.21.
Do any of the versions of of Money sync scheduled transactions with pocket pc? If so, please advise your configuration/version that does this. Thank you, -- Dick Velting See http://money.mvps.org/downloads/pocketpc/default.aspx -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. I do not respond to any emails that I have not specifically asked for. "R Velting" <RVelting@discussions.microsoft.com> wrote in message news:0218FE95-1178-4962-9B1F-663F1C681E63@microsoft.com... > Do any of t...

Outlook shortcut bar #4
I add items to the shortcut bar and delete others. The next time I open Outlook, those I added are gone and those I deleted are back. ...

Rounding Problem #4
I'm performing a golf handicapping sheet and within that sheet I'm using an average of previous scores such as; In cell AM33 I have =average(q33,w33,ac33,ai33)-35 This value ends up as 11.5... My rounding goes up to 12 which is what I desire but... when I utilize that cell value to subtract 2 other values the sheet does not round properly..? Example: In cell AO33 I insert 48 In cell AP33 I insert =sum(AO33-AM33) Looking at AM33 as a 12 and looking at AO33 as 48, I expected the result to be 36 but it shows 37..! How can I make sure that the rounding carries into the new formula ...

Headers #4
How can I copy a picture in the header from a buissness from from work? ...

8 bytes vs. 4 bytes Struct member alignment
Hi, I have an VC++ application which I have to compile on **4 bytes Struct member alignment** in order to read correctly a binary file and pass the data to a complex structure. (As default, VC++ Struct member alignment compilation is 8 bytes. But if I compile as 8 bytes, the element of structure are not correctly interpreted). Part of this project (compiled as 4 bytes) should be integrated into a master application compiled as 8 bytes as default. Which is the way to deal with this 4 bytes and 8 bytes simultaneous? (I would prefer NOT to change the structure members and I would like to keep th...

switch identity #4
Need to recover my 2nd identity (Outlook Express) in Outlook 2003. Main identity works fine. Are there identities in Outlook 03. No, only profiles. What do you mean that you need to "recover" your identity? Outlook has no need for identities. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After furious head scratching, Stu Kilgour asked: | Need to recover my 2nd identity (Outlook Express) in Outlook 2003. | M...

xy scatter line goes below zero
The line drawn in my xy scatter chart goes below zero of the y-axis, is there any way I can stop this? My first 3 points are all zero and then there is a very steep increase, the line that connects them assumes that there is a dip into negative values before the increase when this is not actually the case. Hi, Have you got the Smooth line option ticked? Cheers Andy jon7 wrote: > The line drawn in my xy scatter chart goes below zero of the y-axis, is there > any way I can stop this? My first 3 points are all zero and then there is a > very steep increase, the line that connect...

XML #4
How does one generate a XML code? If you have data in a dataset, you can have the dataset do it automatically: Dim x as string = DataSet.GetXML "Raj" <Raj@discussions.microsoft.com> wrote in message news:BC61AFF2-84EE-425E-8F05-1B02D2A9F317@microsoft.com... > How does one generate a XML code? ...

Mailbox Rights #4
On Exchange 5.5, I can log in to any user's mailbox using an account with the "Service Account Admin." permission. On Exchange 2003, what permissions do I need on a mailbox in order to do the same thing? When I use that same Service Account Admin. account (my Exchange 2003 joined my Exchange 5.5 site) to log in to a user's mailbox, I get an error in Outlook that I am unable to open the folders and Outlook quits. Thank you. Hello, This KB article will help you out: http://support.microsoft.com/default.aspx?scid=kb;[LN];821897 Hope that helps, Russ Maxwell This post...

To MS Support: Budget report bug in Money 2005 (and 2003,4)
Part of our income comes from investments and we have several brokerage accounts which are setup in Money 2002 as investment accounts with a linked cash account. Dividend, interest and capital gains income comes into these accounts and is then transferred to a separate checking account to pay our living expenses. Thus the investment accounts must be included in our budget. Money's budget feature is outstanding and crucial to our financial health. I have tried to upgrade from Money 2002 but am unable to because Money 2003, 2004 and 2005 have a show stopper bug that destroys al...

Tennessee Frist Sales Tax Holiday 8/4/06 to 8/6/06?
Hello, Today I got a memo from the Tennessee Department of Revenue for a Back-to-School Supplies, Clothing, and Computers Tax-Exempt During Tennessee's First Sales Tax Holiday. In August of this year, Tennessee will hold its first annual sales tax holiday, giving shoppers the opportunity to purchase certian school suppliers, computers and clothing tax-free for a specific period of time beginning at 12:01am on Friday, Aug 4 and ending at 11:59pl on Sunday, Aug 6. We have stores on all different parts of Tennessee with different items sales tax base on their location. I saw two opt...

Stats microsoft.public.windowsxp.general (last 7 days) 06-07-10
"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: microsoft.public.windowsxp.general Stats Were Taken..........: Mon, 07 Jun 2010 08:14:28 GMT Stats Begin...............: Mon, 31 May 2010 08:29:11 GMT Stats End.................: Mon, 07 Jun 2010 06:42:42 GMT Days......................: 7 Total No. of Articles.....: 526 Total No. of Characters...: 1263268 Total Volume..............: 1233 Messages Per Day..........: 75.1 Characters Per Day........: 180466.9 Average Daily Volume......: 176 kB Total Posters This Week...:...

General database question
Could someone please give me some input... I need to create a database of my clients....Probably not going to hav more than a couple of thousand entries in a lifetime... However, there are many featuers that I would like to track about eac client first name last name address city state zip phone cell email birthdate spouse name spouse birthdate kids names kids birthdates and a few other fields Is it easier to do this in access rather than excel....the only proble is I know excel much easier than I know access... thanks for any advice.. Jos -- jhahe ---------------------------------...

Forgotten Password #4
I need to gain access to my Money 2001 that I have on an old computer but have forgotten the password that I used back then. Is there any way I can find out what my password was? Does anyone know what file the password is kept in and if it's readable? Any help will be appreciated since it's very important that I retrieve some information from that year which I did not carry forward to the more current years. Thank you! You might be able to find a company which provides software to get the password out for you. I know of three, but there are probably others. http://money.mvps.org/faq...

More than 4 gigs - PAE
Am trying to figure out if. . . I have a server with more than 4 gigs of memory (We'll just say 5 gigs) running Windows Enterprise, and I throw the PAE switch, will the OS take the remaining 2 gigs of memory (After Exchange gets it's 3?) See http://blogs.technet.com/exchange/archive/2005/07/05/407330.aspx With Windows 2003 SP1, we can now throw the PAE switch without harm to the databases, I'm just wondering if it's worth having the extra memory to the OS available. On Fri, 26 Aug 2005 09:02:01 -0400, "Pat DiPersia" <pat@dipersia.com> wrote: >Am trying...

excel goes insanely slow
HI, Im making graphs in 2007, They are called tensile curves and have about 1500 points each. I have 9 curves on one graph. Basically, excel crashes, if i go to change anything (axes scale, line weight, colour, etc) excel goes slower then any program ive ever run, stops responding and eventually (2-10 minutes later) lets me click something. Im running a core 2 duo with ample ram, disk space and operating on xp pro so im doubting its a hardware or OS problem any ideas on what is wrong and/or how to fix it? Thanks, Tom T: An interesting problem. Would you like to send me ( remove TRU...

How do I create a poster consisting of 4 x A4 pages which get glue
I know this can be done as I have done it some yaers before. It may have been in Power Point however. As I remember I created the poster content on the word document page and then using some option/s one is able to segment the page into 4 quarters, print these and then glue them together. I am using Microsoft Office Student and Teacher 2003 Word cannot create posters - try Publisher. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP...

Symantec Antivirus Corp Edition 9.0 & SMSE 4.5
I'm running Symantec Corp Edition 9.0 for file level protection and SMSE 4.5 for exchange. I know I have to exclude the Exchange folders under Symantec Corp Edition 9.0. Do I have to Enable or Disable Microsoft Exchange Auto Protect in 9.0? (Under Configure, Microsoft Exchange Auto-protect)? You would want to enable this so that Symantec will scan any message that comes through your Exchange client (Outlook). If someone sets up internet mail through Outlook you will be protected. Look at the Help that comes with the client and it will explain when you might not want to set this. &q...

check decimal and if numeric
I have an unbound textbox, txtAmount. I want to make sure that user enters only two decimal places, and that the input is numeric. I tried using InputMask 99999999.99 which works for positive numbers, but that mask won't allow the minus sign (or plus sign) to be used. So, how can I allow input of a negative number? Currently, if TransactType is "Payment", it takes the value in Amount * -1 (if existing Amount > 0), so that effectively makes it a negative. But, a TransactType of "Adjustment" could be either negative or positive. I could make a TransactType of "...