Converting to/from Hex or Decimal
To convert values in a spreadsheet from hexadecimal to decimal use the following formula.
=HEX2DEC(H4)
In the example above the cell H4 contains a....
|
Microsoft Excel |
| Entering the current date/time into a cell
Use the formula =NOW() to enter the current date and time into a....
|
Microsoft Excel |
Counting blank cells
Use the following formula to count the number of blank cells within a range of cells in a sheet.
=COUNTBLANK(B1:B15)
This will count the number of blank....
|
Microsoft Excel |
Calculate the number of days in a month
To calculate the number of days in a month, use the following formula.
=DAY(EOMONTH(C4,0))
Where C4 contains a date within the month you are looking for.....
|
Microsoft Excel |
| Comments in a spreadsheet
Comments can be added to a spreadsheet, by simply right-clicking on a cell and selecting Add Comment from the pop up menu. The comment has no effect on the....
|
Microsoft Excel |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| 1
5 Results found.
|
