-
Hide Unnecessary Decimal Markers
D3:E36 is Custom Formatted as ? ???.??? and contains simple multiplication formulas, eg: =(n*n)
I want to hide decimal markers when whole numbers (without decimal places) are returned.
Please see the yellow cells in the attached sample.
Can someone please offer Macros that I can copy & paste?
I am using Excel 2010.
mgs
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules