| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using "Sum" function with Europian numbers
Hi,
You say you are getting "Errors", what error, show us what you expect and what you get. One thing you can do is choose Tools, Options, International and make sure the settings in the Number handling area are correct. You may need to check or uncheck Use system separators, and if checked you may need to change the Decimal separator and/or the Thousands separator. -- Thanks, Shane Devenshire "Aman" wrote: I'm from USA. I handle lots of data with Europian (German) standards. When I use the "sum" function, it's not working for me. For example when I add 5.000,00 and 2.000,00 (written in German standards) I should get a total of 7.000,00. But the system is showing errors (since I'm using US version of excel). How to correct this issue so that I can get correct totals. Aman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Threaded Mode
