Custom Formatting

[Matt McAleer]

In a cell, I want to include a double quote as my custom
formatting.

For example, I want to enter the following in the
formatted cell:
12.43

I want the displayed results to look like:
12.43"

I've looked a few places and cannot find any info. Any
help is appreciated.

Thanks
Matt

 

[Chip Pearson]

Matt,

When you type in the custom number format, use \" to indicate the
double quote mark.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[RagDyer]

Try:

<Format> <Cells> <Number> tab, and click on "Custom".

Click on a format that you like in the right window,
Then, in the "Type" window, add a backslash followed with the double quotes
(\").
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

In a cell, I want to include a double quote as my custom
formatting.

For example, I want to enter the following in the
formatted cell:
12.43

I want the displayed results to look like:
12.43"

I've looked a few places and cannot find any info. Any
help is appreciated.

Thanks
Matt