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?

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

Great question!

Jaleel... just so you don't miss the point, Ron is asking about 255.012 in
comparison to 255.12 (or even 255.0012).

Rick