Separating a number with decimals

[timmy]

Hi Everyone,

I would really appreciate if someone can tell me how I can separate
whole list of numbers in a column which contain 3 decimal places. Th
numbers are as follows

2184.120
2121.010

I want these show separately in the next 2 columns as follows:

2181 120
2121 010

Awaiting your earliest replies.

Cheers,

Timm

 

[Norman Harker]

Hi Timmy!

Add a couple of helper columns and then use:

=INT(A1)
=MOD(A1,1)*1000

If you want to delete the original data, make sure that you copy >
paste special > Values the helper columns first.

 

[timmy]

Thanks Norman, it worked !

Cheers,

Timmy

*Hi Timmy!

Add a couple of helper columns and then use:

=INT(A1)
=MOD(A1,1)*1000

If you want to delete the original data, make sure that you copy >
paste special > Values the helper columns first.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

 

[Norman Harker]

Hi Timmy!

Always pleased to help.