Here is another way...

A1: 255.875
B1: =INT(A1)
C1: =IF(ISNUMBER(FIND(".",A1)),--SUBSTITUTE(A1,B1&".","",1),0)

This will work no matter how many digits follow the decimal point.

Rick


"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