View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Split a decimal figure

On Sun, 24 Aug 2008 22:38:01 -0700, Jaleel
wrote:

Hi,

I have a figure in A1. For example, 255.875

Is it possible to bring 255 in B1 and 875 in C1 as numbers, not text?

Regards,

Jaleel


What do you want to show, in C1, if A1: 255.012
--ron