Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stange numbers
Hello all,
Some one in my office has ask me for help and I could not figure this out. The setup:you have a set of rows with number and those number are formatted with "Accounting" two decimals no symbol. When doing a manual sum or using the AutoSum, whey would my number come out like so 0.00 and not a dash? If you increase the decimal out there is a number, 0.00000000000000164316543. ?? The number are whole numbers, e.g. 24.25, 100.25, 562.64 ect. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |