You haven't said what you want if there isn't a decimal point, but try
=IF(MOD(A1,1)=0,"",--RIGHT(A1,LEN(A1)-FIND(".",A1))) and modify to suit.
--
David Biddulph

"Jaleel" wrote in message
...
Hi,

Thanks to both of you. I am working on a tender document and so text
column
exercise cannot be done. However, the formula of Bernd is practical.
Cell
B1 is OK. But in C1 I am not getting the desired 855. It shows 0.850.
Any
other options?

Regards,

Jaleel


"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