View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
meridklt meridklt is offline
external usenet poster
 
Posts: 4
Default Split number with decimal places into 2 columns

I need a formular (if it can be done) to extract a number with decimal places
onto 2 columns.

Example:
Column A has the number and I want the whole number in B and the decimal in C
A B C
123.456 123 .456