big problem

W

Wu

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
 
F

FSt1

hi,
not big probem. small problem..... not even problem, really...
=mod(A2,1)

copy(drag) down.
regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top