LinkBack URL
About LinkBacks
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.
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.
Enter this as your custom format.
Pete
[>=1000000] #,##0.0,,;[>0] #,##0.0,;General
duplicate post.
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")
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks