You can use text to columns

Highlight the data go to

Data-Text-to-Columns

Click on Next, then click the "Other" box and type in a period


"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