ExcelBanter - how i change standart format to comments?

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

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

- - how i change standart format to comments? (https://www.excelbanter.com/excel-discussion-misc-queries/194486-how-i-change-standart-format-comments.html)

known

how i change standart format to comments?

Bernard Liengme

how i change standart format to comments?

If you mean 'formulas': precede them with a single quote (aka 'apostrophe')
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"known" wrote in message
...

Gord Dibben

how i change standart format to comments?

If you mean change the formatting of text in a cell Comment, the only change you
can make without code is to change the Font Size

See Debra Dalgleish's site for more on re-formatting Comments.

http://www.contextures.on.ca/xlcomments02.html

Gord Dibben MS Excel MVP

On Fri, 11 Jul 2008 04:31:01 -0700, known
wrote:

All times are GMT +1. The time now is 07:17 AM.