Add a text comment in a numeric cell with Excel
Basj
Is there a way with Excel, to put a comment with a numeric cell, like the cell A3 here:
such that formulas like =SUM(A1:A5) still work?
Here the wanted result would be 19.
Here it doesn't work because A3 is parsed as a text cell. Sometimes it would be useful to put a number in a cell, with a comment to explain this number.
Is there a trick to do this without creating an extra "comment" column?
Sanu_012
This can be easily done using the comment feature. Once you enter your number in a cell and press enter, select that cell and press Shift+F2 and you will see an option to add comment right there. See this:
It works quite well and the shortcuts ensures that you don't have to switch between tabs or use your mouse much. The commented cells are marked by a small coloured triangle at the top as shown above. Also, editing the comment is pretty easy. Select and use the shortcut once again.
I hope this helps :)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How can I turn off notification sounds in Microsoft Teams?
- Next: ffmpeg: preserve timestamps when capturing from alsa/madi to mpeg-ts
Related
Related Related
- 1
How do I assign numeric values to text in one cell in Excel or Numbers and add them
- 2
Check if Excel cell text is numeric using formula only
- 3
How to add a text automatically to an excel cell when a cell or cells are filled?
- 4
How do you add text to the end of a cell in Excel
- 5
Excel VBA code how to add text to specific cell
- 6
Add text to each cell of a particular column of an existing excel file with python
- 7
Why does Excel treat long numeric strings as scientific notation even after changing cell format to text
- 8
Excel - Change cell colour based on a date in the comment or mixed in with text
- 9
Modified the text in excel cell?
- 10
Finding and copy numeric value in excel cell
- 11
Finding and copy numeric value in excel cell
- 12
i want to convert my numeric value to text in excel. ex:In A1 cell have "2" then convert to that value "Two"
- 13
Add link to text within cell, not entire cell
- 14
Display Excel cell that contains text
- 15
Not able to delete text in an excel cell
- 16
Convert cell reference to text in Excel
- 17
Excel: Automatic replacement of text in a cell
- 18
How to add colspan and text in cell?
- 19
Add text in clipboard as hyperlink to a cell
- 20
How do you add text wrapping to a cell using OpenXml when creating excel files?
- 21
How add text to a cell in Excel 2013 based on the absence of specific words/sentence?
- 22
add contents of a cell to text file if checkbox is checked using excel 2010 vba
- 23
excel: what is the formula to add comma, single quotes before and after the text in a cell
- 24
importing Data table to Excel text becomes numeric
- 25
How to embed numeric string in text in Excel?
- 26
Excel data validation including numeric and text criteria
- 27
how to change text to numeric in VBA Excel
- 28
Excel adding a comment onto a cell
- 29
Delete row if first cell isn't numeric vba Excel
Comments