Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
Dear Otten,
Thank you for your reply. I checked in the tooloptions........and i found that use system separator was checked thus thousand and decimal separators were not set to a dot. I still have the same problem though. How can one check it in windows settings as you told me so? Thanks. "Niek Otten" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
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 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
StartControl PanelDate, Time, Language and regional optionsChange the format of numbers, dates, and timesRegional
OptionsCustomizeDigit grouping symbol -- Kind regards, Niek Otten Microsoft MVP - Excel "Olivier" wrote in message ... | 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 | 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 | | | |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
Start menu, Control Panel, Regional Options, ... format of numbers ...
-- David Biddulph "Olivier" wrote in message ... Dear Otten, Thank you for your reply. I checked in the tooloptions........and i found that use system separator was checked thus thousand and decimal separators were not set to a dot. I still have the same problem though. How can one check it in windows settings as you told me so? Thanks. "Niek Otten" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula and numbering
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: StartControl PanelDate, Time, Language and regional optionsChange the format of numbers, dates, and timesRegional OptionsCustomizeDigit grouping symbol -- Kind regards, Niek Otten Microsoft MVP - Excel "Olivier" wrote in message ... | 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 | 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 | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Excel 2000 numbering add-in | Excel Discussion (Misc queries) | |||
Excel/VBA Automatic Numbering | New Users to Excel | |||
Need Help with Excel page numbering | New Users to Excel | |||
excel numbering add-in | Excel Discussion (Misc queries) |