I have number between 1M to 10M. So I wanted to format to show
1 M instead of 1 000 000
So I went to format cells-->custom and typed #,, M
But excel gave me error message
I had to write it like this #,,"M"
Why is that? If I wrote #,,K
excel wont give me error message. So only when I...