how to split one decimal pt integer off & to next columnin excel?
 

i need to work on just the decimal part of a number - so: how do i split it
off - in format xx.0 - to put the "0" part into a cell in next column?

how to split one decimal pt integer off & to next columnin excel?
 

Hi

Select the range with numbers;
From Data menu - Text to Columns (NB! You must have an empty column next to
one with data!)
Next
Type period (.) into Other field
Finish

When you need to preserve original numbers, make a copy the column with them
before. Or use formulas in 2 new columns - like
=INT(A2)
=MOD(A2,1)*N
where N is max number of decimal places in your numbers.

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Roger Knights" <Roger wrote in message
...
i need to work on just the decimal part of a number - so: how do i split it
off - in format xx.0 - to put the "0" part into a cell in next column?

how to split one decimal pt integer off & to next columnin excel?
 

Hi again! Sorry, the last formula must be
=MOD(A2,1)*10^N

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )

how to split one decimal pt integer off & to next columnin exc
 

Thanks - exactly what i wanted:)

Roger Knights

"Arvi Laanemets" wrote:

Hi again! Sorry, the last formula must be
=MOD(A2,1)*10^N

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )