Conversions

[Voodoodan]

Hello!

Can anyone show me how to convert the following please?

Any digits ending with '.2', for instance, '29.2', should be shown a
'29.12'.

'.2' should show as '.12'
'.4' should show as '.24'
'.6' should show as '.36'
'.8' should show as '.48'

Any ideas would be appreciated.

Many thanks,
Dan

 

[Andy B]

Hi

Try this:

=INT(C12)+((C12-(INT(C12)))*0.6)

Andy.

 

[BrianB]

Try this in another column:-

=INT(A1)+(A1-INT(A1))*0.

 

[Voodoodan]

Thanks Brian, that's exactly what I wanted.

Dan.