Re: Excel formula and numbering

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dear Niek,

Thank you for your support. It did work pretty well, i don't know how i can
thank you. God bless you and thanks again.

Regards

Olivier

"Niek Otten" wrote:

Start>Control Panel>Date, Time, Language and regional options>Change the format of numbers, dates, and times>Regional
Options>Customize>Digit grouping symbol


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Olivier" <Olivier@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5499261E-B871-4F0B-ACAF-DB29C639DDB2@xxxxxxxxxxxxxxxx
| Dear Otten,
|
| Thank you for your reply. I tried the tools,options....link,and i found the
| Use system separators checked thus meaning that the thousands and decimal
| separator were not set to dot. I still get the same problem though. How would
| one look in the windows settings as you suggested?
|
| Thanks.
|
| "Niek Otten" wrote:
|
| > Hi Olivier,
| >
| > Looks like your thousands separator is set to a dot. Look both in the Windows settings AND in
| > Tools>Options>International>Thousands separator/Use system separators
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > "Olivier" <Olivier@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C1310405-8FDB-4C5B-85E0-F6D1EB2DD17E@xxxxxxxxxxxxxxxx
| > | Dear all,
| > |
| > | I have been trying to add number in excel 2003 with decimals, but some works
| > | and others not. In format cells i put the decimal places to 3. Lets say i use
| > | number 554.965 and excel takes it as 554965, but a number such as 38 excel
| > | takes it as 38 normally,when I add both expecting to have 592.965, i get this
| > | answer 555003.000, again when I make the numbers to use the 1000's separator
| > | it gives me something like this 555003.0.000. Would you help me correct my
| > | report?
| > |
| > | Thank you in advance for your support and understanding.
| > |
| > | Olivier
| >
| >
| >



.

Relevant Pages

  • Re: Excel formula and numbering
    ... Kind regards, ... Microsoft MVP - Excel ... |> Hi Olivier, ...
    (microsoft.public.excel.misc)
  • Re: Remove characters from string
    ... Kind regards, ... Microsoft MVP - Excel ... | there expaining regular expressions unless you meant I should search for it. ... |> | the string I remove extraneous characters. ...
    (microsoft.public.excel.programming)
  • Re: APM/SHUT DOWN PC PROBLEM
    ... Thank you very much Carey Frisch, Microsoft MVP, Windows ... >| I am trying to setup my Advanced APM Power Support so I ... >| outdated BIOS motherboard configuration settings of my ...
    (microsoft.public.windowsxp.hardware)
  • Re: "The Document Name or Path Is Not Valid"
    ... > CD but I get the same error message with both copies. ... >>support call if it is established that you need the ... >>Microsoft MVP ... >>> tried "Open and Repair" with no luck. ...
    (microsoft.public.word.application.errors)
  • Re: instability with MCE 2005??
    ... "Gary Tsang" wrote: ... Microsoft MVP - Windows XP Shell/User ... see Help and Support Center at ... The Diskeeper Control Center has been started. ...
    (microsoft.public.windows.mediacenter)