ExcelBanter - ascii character in custom format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ascii character in custom format (https://www.excelbanter.com/excel-discussion-misc-queries/115339-ascii-character-custom-format.html)

Mike K

ascii character in custom format

Oh Wise Ones,
I know I've seen this before but I can't find it in
search. How do I put a special character in the custom formatting? I would
like to add a superscript 3 to the end of a number string #.###(cubed).
Please advise.

Many thanks,
Mike

Andy Pope

ascii character in custom format

Hi,

In the Type textbox enter ALT+0179 (numeric keyboard) at the end of the
hashes.

#.###³

Cheers
Andy

Mike K wrote:
Oh Wise Ones,
I know I've seen this before but I can't find it in
search. How do I put a special character in the custom formatting? I would
like to add a superscript 3 to the end of a number string #.###(cubed).
Please advise.

Many thanks,
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Mike K

ascii character in custom format

Thanks Andy

"Andy Pope" wrote:

Hi,

In the Type textbox enter ALT+0179 (numeric keyboard) at the end of the
hashes.

#.###³

Cheers
Andy

Mike K wrote:
Oh Wise Ones,
I know I've seen this before but I can't find it in
search. How do I put a special character in the custom formatting? I would
like to add a superscript 3 to the end of a number string #.###(cubed).
Please advise.

Many thanks,
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 12:53 PM.