QUESTION : I know the question title isn’t great, I can’t think of a good way to phrase the question, […]
Tag: cell-format
excel clear sets format as accounting
QUESTION : In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number […]
Add space between numbers in Excel
QUESTION : How to I add space automatically to a 22-digit number? For example: 1234567891234567891234 needs to be formatted to […]
How do I format a number in an “=CELL” type of statement?
QUESTION : I have a spreadsheet where cell A1 is 1234.56789. In cell B1, I have =”$”&A1. This shows up […]
Dynamic rule to change the color of a cell when a check box is true
QUESTION : The following code automatically links any CheckBox in the active sheet to one cell before the checkbox. In […]
Filtering empty cells
QUESTION : Notice that B2 and B3 are merged and a filter is created on the B column When I’m […]
How to display multi lines in an Excel cell WITHOUT wrapping
QUESTION : I know about using Alt+Enter to add carriage returns to a cell, and they display fine at the […]
Excel date format with abbreviated month without the dot
QUESTION : Hi, I am using this formula for custom date format in Excel: [$-es-ES]d-mmm-yyyy and this is what I […]
Dynamic rule to change the color of a cell when a check box is true
QUESTION : The following code automatically links any CheckBox in the active sheet to one cell before the checkbox. In […]
StackExchange Number Format in Excel
QUESTION : I’ve grown to love the StackExchange number format for question views: after a particular question passes 1000 views, […]
- 1
- 2