Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number
Loading...
Loading...
3:47
Excel Magic Trick 522: 30 Days In Each Month Calculationsby ExcelIsFun1,017 views- 25:52
Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methodsby ExcelIsFun3,806 views
- 2:15
Excel Magic Trick 525: Advanced Filter With Wild Cardsby ExcelIsFun4,376 views
- 6:29
Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCHby ExcelIsFun3,526 views
- 4:41
Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)by ExcelIsFun5,439 views
- 1:45
Fill in Blank Cells in Excel Pivot Tableby XLXBERT1,020 views
- 4:47
Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCTby ExcelIsFun5,028 views
- 1:49
Excel Magic Trick 543: Build Time Schedule With 15 Minute Intervalsby ExcelIsFun4,373 views
- 10:29
Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functionsby ExcelIsFun3,587 views
- 5:33
Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Productby ExcelIsFun1,047 views
- 4:45
Excel Magic Trick 561: Wildcards * and ?by ExcelIsFun1,783 views
- 5:01
Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computerby ExcelIsFun1,289 views
- 5:00
Excel Magic Trick 566: Conditional Format A Chart Student Gradesby ExcelIsFun5,058 views
- 8:32
Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Methodby ExcelIsFun4,251 views
- 2:31
Excel Magic Trick 567: Collapsible Expandable Cell Rangesby ExcelIsFun3,881 views
- 3:58
Use Excel's GoTo Special Dialog Box to Find Your Formulasby DannyRocksExcels1,920 views
- 2:31
Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font Whiteby ExcelIsFun2,787 views
- 7:11
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheetby ExcelIsFun34,115 views
- 1:46
Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Featureby ExcelIsFun6,918 views
- 7:57
Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Functionby ExcelIsFun3,853 views
You are welcome!
ExcelIsFun 8 months ago
Thank you!
jonathan92591 8 months ago
I do not know how to place a format unless something is in the cell.
If you have a zero in each cell instead of a blank, you could use the Accounting Number format without a dollar sign and that would show a "-" for each zero.
Accounting Number format without a dollar sign looks something like this:
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
ExcelIsFun 2 years ago
what if i wan2 have a centre formatted "-" in place of a blank?
khurram87 2 years ago