Thread: Decimal Places
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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