Forum Discussion
Solved
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 ha...
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.
