Custom Format of a cell

[ab1275]

I am trying to find a way to custom format a cell to get the following when I use wrap text on the cell:

91%
Target

I customized the cell format with "00% "Target" but even with wrap text I don't get the above format. When I resize the cell I get ########.

I tried using CHAR(10) but that didn't work.

Please help!

 

[mumps]

Try: 0% - "Target"

 

[Rick Rothstein]

I am trying to find a way to custom format a cell to get the following when I use wrap text on the cell:

91%
Target

Try it this way... type this into the Type field of the Custom Format option...

91%"Target

then click the mouse between the percent sign and the first equal sign and press CTRL+J on the keyboard (it will look like the "Target" part disappeared... it didn't... it is on the next line which the Type field cannot show to you), then click the OK button.

 

[ab1275]

Try: 0% - "Target"

That didn't seem to work

 

[ab1275]

Try it this way... type this into the Type field of the Custom Format option...

91%"Target

then click the mouse between the percent sign and the first equal sign and press CTRL+J on the keyboard (it will look like the "Target" part disappeared... it didn't... it is on the next line which the Type field cannot show to you), then click the OK button.

That did work!!! Thank you so much! Now my cell is much smaller than it was before! Much appreciated!