Forum Discussion
waglagla
Apr 28, 2020Copper Contributor
numbers in thousand and million
Hello everyone,
I am trying to save space by shorting my numbers.
i gave an example in the file below, i know how to manually set-up each cell in either thousands or millions. but since my sheet has data validation in column K, the number in column will vary depending on the data of K, so i would like to have the column M to automatically write the number in single digit,thousands or millions if possible.
thank you
Hi waglagla
You can use custom formating with the following text.
[>999999]#,##0.000,,"M";[>999]#,##0.0,"K";#
I have attached a sample file for easier understanding.
Cheers.