I would like to format big numbers in Excel in such a way that only the two most significant digits are displayed. Remaining digits would be padded with additional zero. 

Example:

1234567 would be displayed as 1 200 000  

and  

1234 would be displayed as 1 200

Using the format # # " 000" would display 1234567 as 1 235 000 but this is not what I am looking for because it does not scale to one-digit-less numbers. Solutions like 1.2 M is not what I am looking for neither. 

The same format should work for both examples. I don't want to round the number, but round the displayed value only (the format).