Hello. I have a long list of numbers - some are whole numbers and some are showing 6-7 decimals. I need to be able to convert the decimals into whole numbers. the reason is that i am trying to pull a pivot to count these numbers. The pivot is counting those numbers as decimal even though i tried converting them into numbers no decimals in the data file. the pivot table won't reflect the conversion. I have tried converting them into numbers or text or general none of which helped with my pivot table.
Please see my sample data and pivot attached.Attachment 274264 Will someone look at this and advise?
Thank you!!
Bookmarks