ExcelBanter - excel quotes

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel quotes (https://www.excelbanter.com/excel-worksheet-functions/85664-excel-quotes.html)

How can I format a cell to have quotes around the contents in excel

For numbers:
\"#\"

For text:
\"@\"
--

HTH,

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

"Old Maps" <Old wrote in message
...
How can I format a cell to have quotes around the contents in excel

Thanks,

That works great!

"RagDyeR" wrote:

For numbers:
\"#\"

For text:
\"@\"
--

HTH,

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

"Old Maps" <Old wrote in message
...
How can I format a cell to have quotes around the contents in excel

Thanks for the feed-back.

--

Regards,

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

"Old Maps" wrote in message
...
Thanks,

That works great!

"RagDyeR" wrote:

For numbers:
\"#\"

For text:
\"@\"
--

HTH,

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

"Old Maps" <Old wrote in message
...
How can I format a cell to have quotes around the contents in excel