How to separate numbers after decimal point

**Ozwilly** · 10-02-2011, 08:28 PM

Hi,

I have a need to convert a range of numbers so that only a part of the number is placed into a separate cell. For example I would have the following list:

345.65
6543.34
76.22
3456.87
456.32

I need to be able to extract from these numbers so that in a separate column I get only the decimal point and numbers after it.

ie.
.65
.34
.22
.87
.32

I have not been able to do this, any help would be greatly appreciated

**khamilton** · 10-02-2011, 08:36 PM

If the decimal is always the third character use this replacing Your cell..

=Right(Your cell,3)

**Nazerith** · 10-02-2011, 08:46 PM

=RIGHT(a1,3)

if this Fixed your problem please use the scales to rate my help

**Ozwilly** · 10-02-2011, 09:25 PM

Thanks, worked brilliantly

Originally Posted by Ozwilly

Hi,

I have a need to convert a range of numbers so that only a part of the number is placed into a separate cell. For example I would have the following list:

345.65
6543.34
76.22
3456.87
456.32

I need to be able to extract from these numbers so that in a separate column I get only the decimal point and numbers after it.

ie.
.65
.34
.22
.87
.32

I have not been able to do this, any help would be greatly appreciated