The period character forces the value to truncate, while the last two pound signs display the appropriately rounded digits. This format retains the scale, without losing any values and without misrepresenting the values. The period after the semi-colon is grammatical and not part of the format string.) As you can see below, the results arent accurate. You could add a few pound signs, but you might not get what you expect.įor instance, repeat the instructions above and use the format string, M. The results look good, but a couple of values disappeared Thats because those numbers are less than one million. The M component displays a literal M character, to denote millions.Ĭlick OK. The pound sign combined with the two comma characters displays a character in the millions position, if one exists. We can reduce the number of digits using a custom format, but be careful you might get some unexpected results (Were specifically working with millions, but you can apply this technique to any scale.) LEARN MORE: Office 365 Consumer pricing and features Now, lets try a custom format and see what happens: Select the data range and press Ctrl1 to display the Format Cells dialog. For example, the sheet below shows a number of large numbers, some in the millions.
0 Comments
Leave a Reply. |