| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert 10 Decimal Places to 2
I need to convert a column of figures such as 136.573297808087 to 136.57
preferably automatically. This is not just for display purposes, but the content of each cell must only contain 2 decimal places. It is being used as a database for a Word merge. When the column is merged into the word document, it displays all 12 decimal places, but I only want it to display 2. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert 10 Decimal Places to 2
trya helper column wtih this formula copied down as needed:
=ROUND(A2,2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sheri-NWC" wrote: I need to convert a column of figures such as 136.573297808087 to 136.57 preferably automatically. This is not just for display purposes, but the content of each cell must only contain 2 decimal places. It is being used as a database for a Word merge. When the column is merged into the word document, it displays all 12 decimal places, but I only want it to display 2. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert 10 Decimal Places to 2
THANK YOU!!!!!! You have just me a HUGE amount of re-entry.
Sheri "Luke M" wrote: trya helper column wtih this formula copied down as needed: =ROUND(A2,2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sheri-NWC" wrote: I need to convert a column of figures such as 136.573297808087 to 136.57 preferably automatically. This is not just for display purposes, but the content of each cell must only contain 2 decimal places. It is being used as a database for a Word merge. When the column is merged into the word document, it displays all 12 decimal places, but I only want it to display 2. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert 10 Decimal Places to 2
You're welcome, and thanks for the feedback. =)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sheri-NWC" wrote: THANK YOU!!!!!! You have just me a HUGE amount of re-entry. Sheri "Luke M" wrote: trya helper column wtih this formula copied down as needed: =ROUND(A2,2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sheri-NWC" wrote: I need to convert a column of figures such as 136.573297808087 to 136.57 preferably automatically. This is not just for display purposes, but the content of each cell must only contain 2 decimal places. It is being used as a database for a Word merge. When the column is merged into the word document, it displays all 12 decimal places, but I only want it to display 2. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal places | Excel Discussion (Misc queries) | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Linear Mode
