Separating a number with decimals

  • Thread starter Thread starter timmy
  • Start date Start date
T

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
 
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.
 
Thanks Norman, it worked !

Cheers,

Timmy :)




Norman said:
*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)
Click to expand...
 
Back
Top