View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
 
Posts: 510
Default 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