Splitting Numbers Into Different Columns
Hi Peter
Assuming numbers are column A :
in column B just type formula =Int(A1) and then Format Cells Number
Custom 0000
and copy this formula all the way down
in column C just type formula = B1-A1 and Format Cells Number Number 2
decimals
HTH
Cheers
Carim
|