Hi
Unfortunately I don't think you have the simple solution you want just using formatting.
You could use a formula (for ex. with Text()) that formats the number as you want. It will, however, no longer be a number.
There is a way to work around it, that may or may not be adequate to your case: you can use a 2-line format and hide the second line.
You may try it and then see if it suits your needs:
1 - Select a cell and enter 1545785
2 - enter the custom format
0.00,,,%%
before pressing OK in the format, place the cursor between the last comma and the first % and press Ctrl-J. This inserts a linefeed.
Press OK.
3 - turn the Wrap text on. Make sure the row heigth stays the same. You should see in the cell
15.46
as you want.
Notice that what is displayed in the cell is a 2 line text
15.46
%%
You can confirm this by increasing the row height. By not increasing the row height you are in fact hiding the second line, that you don't want to see.
This is just formatting, the value in the cell does not change, it is still a number value that you may use for calculations.
Does this help?
Remarks:
I've experienced some problems when I want, later on, to access this type of 2-line format from the custom format form. To copy the format to other cells I use instead copy->paste format.
There might be other solutions involving vba or windows.
