Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
big problem
After calculation, there are some data contain decimal, how to use function
or other methods to change from case a to case b? case a: 1.1 1.2 1.6 2.2 case b: 0.1 0.2 0.6 0.2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
big problem
hi,
not big probem. small problem..... not even problem, really... =mod(A2,1) copy(drag) down. regards FSt1 "Wu" wrote: After calculation, there are some data contain decimal, how to use function or other methods to change from case a to case b? case a: 1.1 1.2 1.6 2.2 case b: 0.1 0.2 0.6 0.2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |