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?

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?

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

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

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 )