You have a number 123456789 and you quickly want to apply Thousand Separator Custom Format with Two Decimal Places. Hence, you are seeking an answer of 123,456,789.00.
Excel has already provided a short cut to do the same –
CTRL+SHIFT+!
You have a number 123456789 and you quickly want to apply Thousand Separator Custom Format with Two Decimal Places. Hence, you are seeking an answer of 123,456,789.00.
Excel has already provided a short cut to do the same –
CTRL+SHIFT+!