Help with Formatting Cell with Custom Number Format

[Oryan77]

I am trying to use this trick to get a cell to display a whole number while the value of the cell still shows the decimal place:

https://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/

I am formatting a cell with "##,%%" (or "##,{Ctrl J}<ctrl j=""></ctrl>%%" (where Ctrl J is pressed in order to enter the %% as a Carriage Return aka new line) in order to get a cell value of "0.5" to display as "5" but still show "0.5" as the value. Word wrap is activated. This works.

However, I also need to get another cell with a value of "0.05" to also display as "5" (while the cell value is still "0.05").

I cannot get this to work. None of my attempts are displaying the cell as "5". I can get it to display "50" while the value is "0.05". I can also get it to display "1" while the value is "0.05". I cannot get it to display "5" while the value is "0.05".

Any help?

 

[Tetra201]

Maybe #{Ctrl J}%

 

[Oryan77]

Maybe #{Ctrl J}%

I have tried that also but for some reason it changes the value of the cell from 0.05 to 5%. So the cell shows 5 but the value shows 5%.

 

[Tetra201]

Then try #{Ctrl J}E-2

 

[pkdeimos]

For this trick to work, you have to "Wrap text".

Cheers

 

[Oryan77]

Then try #{Ctrl J}E-2

Aha! That was it. Thank you very much.