Help with custom text format

**stephme55** · 06-23-2016, 03:00 PM

Hello. I'm doing this custom text format $#.#,," Mil"; How can I get it to show 71.0 for a number like 71,000,003. Right now it's showing 71.

**PeteABC123** · 06-23-2016, 03:34 PM

Enter this as your custom format.

Please Login or Register  to view this content.

Pete

**PeteABC123** · 06-23-2016, 03:35 PM

duplicate post.

**MrShorty** · 06-23-2016, 03:40 PM

I would recommend further study of this help file: https://support.office.com/en-us/art...2-09fab54be7f4 In particular study the section that describes the behavior of the 3 main placeholders -- 0, #, ? (section titled "Guidelines for using decimal places, spaces, colors, and conditions")