View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Splitting decimals

I need to split a figure with a decimal value of 2 places, into 2 seperate
cells.

EG
I have a figure of 1.56 in cell a1
and I want to split it into
A2 and A3
A2 will hold the number before the decimal point and A3 will hold the number
after the decimal point.

Thanks