CONCATENATE
 

how do i to control the dicimal place to 3 dicimal place
e.g 1.50375939849624 kw
to 1.504 kw

Right Click - Format Cells - Number ( Category ) - Decimal Places
: 2


--
excel_googler
------------------------------------------------------------------------
excel_googler's Profile: http://www.excelforum.com/member.php...o&userid=16610
View this thread: http://www.excelforum.com/showthread...hreadid=314736

enter it just as a number, and format the cell as 0.000kw

--

HTH

RP
(remove nothere from the email address if mailing direct)


"yokiboy" wrote in message
...
how do i to control the dicimal place to 3 dicimal place
e.g 1.50375939849624 kw
to 1.504 kw

Hi

you have two options -
1) format the cell to only show three decimal places (click on the cell,
choose format / cell / number - decimal places 3, OK). Using this method
the original value will still be used in calculations
or
2)round the number to three decimal places - in an adjacent cell type
=ROUND(A1,3)
where A1 is the cell reference of your number. You can then copy it, click
on the original number and choose edit / paste special - values to replace
the original number with the result (and then you can delete the other
cell). In this way, the "rounded" value will be used in future
calculations.

Cheers
JulieD


"yokiboy" wrote in message
...
how do i to control the dicimal place to 3 dicimal place
e.g 1.50375939849624 kw
to 1.504 kw