ExcelBanter - custom number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - custom number format (https://www.excelbanter.com/excel-discussion-misc-queries/21660-re-custom-number-format.html)

Ron Coderre

custom number format

Try playing with this custom format:
#,##0,,"MM"_);(#,##0,,"MM");#,##0,,"MM"_)

Regards,
Ron

Ron Coderre

Here's a variation that actually does what you asked for:
#,##0.0,,"MM"_);(#,##0.0,,"MM");#,##0.0,,"MM"_)

Ron

All times are GMT +1. The time now is 02:50 PM.