I don't understand example 3. Isn't 10.065 less than 2025?

For the first two examples, perhaps:
=IF(VALUE(LEFT(A1,4))<=2025,VALUE(LEFT(A1,4)),VALU E(LEFT(A1,3)))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric" wrote:

Does anyone have any suggestions on how to find the number?

Example 1:
There is a number 19650 in cell A1, I would like to fit this number below
2025, therefore, it should return 1965 in cell B1.

Example 2:
There is a number 25624 in cell A1, I would like to fit this number below
2025, therefore, it should return 256 in cell B1.

Example 3:
There is a number 10.065 in cell A1, I would like to fit this number below
2025, therefore, it should return 1006 in cell B1.

Does anyone have any suggestions on how to set the formula to do it?
Thanks in advance for any suggestions
Eric