Decimal Values

[CARBOB]

Can decimal values be converted to whole numbers?

0.39
0.28
0.20
0.40
0.29

 

[shg]

Multiply by 100?

 

[cerfani]

you can round them

 

[Rick Rothstein]

Can decimal values be converted to whole numbers?

0.39
0.28
0.20
0.40
0.29

What do you mean by "converted to whole numbers"... what whole numbers did you want them converted to? My guess is what shg wrote in Message #2 , but it is possible you have something else in mind. Also, did you want whatever it is you meant by "converted to whole numbers" to overwrite the existing values within their original cells or did you want a formula that can display the conversion in a different set of cells?

 

[CARBOB]

What do you mean by "converted to whole numbers"... what whole numbers did you want them converted to? My guess is what shg wrote in Message #2 , but it is possible you have something else in mind. Also, did you want whatever it is you meant by "converted to whole numbers" to overwrite the existing values within their original cells or did you want a formula that can display the conversion in a different set of cells?

Thanks to both of you for responding. I had a formula wrong which produce the decimal value.