Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
I have a client who cuts and pastes data from my Excel spreadsheets. My
spreadsheets display the actual integer values (such as 42, 39, etc.) but when they copy and paste they get 41.888876 or 39.443267. Is there a way to "set" the decimal value so that they get a rounded integer? Thanks for your help. MJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
Format cells as Number with zero decimal places. This only DISPLAYS as
integers but will calculate as decimal numbers e.g. 41.888876 "Tafmutt" wrote: I have a client who cuts and pastes data from my Excel spreadsheets. My spreadsheets display the actual integer values (such as 42, 39, etc.) but when they copy and paste they get 41.888876 or 39.443267. Is there a way to "set" the decimal value so that they get a rounded integer? Thanks for your help. MJ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
Hi,
I think you have some formulas in your worksheet and these figurs are result of those formulas so the thing is that you have to put your formulas in a round function like below: =ROUND(your formula,2) Thanks, -- Farhad Hodjat "Tafmutt" wrote: I have a client who cuts and pastes data from my Excel spreadsheets. My spreadsheets display the actual integer values (such as 42, 39, etc.) but when they copy and paste they get 41.888876 or 39.443267. Is there a way to "set" the decimal value so that they get a rounded integer? Thanks for your help. MJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
decimal places | Excel Discussion (Misc queries) | |||
add 2 decimal places | Excel Discussion (Misc queries) |