View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Excel formula and numbering

Hi Olivier,

Looks like your thousands separator is set to a dot. Look both in the Windows settings AND in
ToolsOptionsInternationalThousands separator/Use system separators

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Olivier" wrote in message ...
| 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