Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CONCATENATE
how do i to control the dicimal place to 3 dicimal place
e.g 1.50375939849624 kw to 1.504 kw |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
UDF to evaluate result of concatenate() with additional arg. | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
How to Concatenate Time with some operator? | Excel Worksheet Functions | |||
Concatenate and make uniform | Excel Worksheet Functions |