Excel Magic Trick #503: Custom Number Format For Turnover Ratio
Loading...
Loading...
1,938
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (5)
-
Very neat trick...didn't know about adding comments after custom setup.
Loading...
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun568 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,314 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 7:32Financial Analysis Using Excel, Part 1 (Time Va...by ToweringSkills41,508 views
- 3:34Excel Magic Trick #235: Custom Number Format fo...by ExcelIsFun2,141 views
- 3:08Excel Magic Trick 499: Does Cell Have Number or...by ExcelIsFun2,492 views
- 11:19Mr Excel & excelisfun Trick 83: PowerPivot or H...by ExcelIsFun2,569 views
- 2:21YTLE#73: Custom Number Format 00000by ExcelIsFun1,145 views
- 8:40Office 2010 Class 50: Word Letter Mail Merge w ...by ExcelIsFun6,293 views
- 1:47Excel Magic Trick #201: Custom Number Format Fo...by ExcelIsFun2,627 views
- 26:38Highline Excel Class 27: Custom Number Format &...by ExcelIsFun11,057 views
- 6:44Excel Magic Trick #236: Excel For Home Improvementby ExcelIsFun4,436 views
- 3:31Excel Magic Trick 433: Custom Number Format for...by ExcelIsFun1,387 views
- 4:49Excel Magic Tricks # 1: Formulas & Cell Referencesby ExcelIsFun104,439 views
- 1:40Excel Magic Trick 523: Fill In Blanks With Cust...by ExcelIsFun1,515 views
- 9:52Excel MT142 p1: Custom Number Format & Conditio...by ExcelIsFun5,441 views
- 10:22Excel Basics #12: Stylistic & Number Formattingby ExcelIsFun32,053 views
- 7:50Excel Magic Trick #184: Setup Database in Excelby ExcelIsFun93,527 views
- 6:49Mr Excel & excelisfun Trick 60: Conditional For...by ExcelIsFun2,102 views
Many thanks for your help. It works fantastic I have safed so much time at my work since I´m watching your video !! Greeding from Germany!!
Karin16121968 10 months ago
You are welcome! If you like the video, I just published my forst book:
"Slaying Excel Dragons". You can get it at Amazon!
ExcelIsFun 10 months ago
Hi I would appreciate your help, I´m trying to custom my cell as follow 589 589 00 00 to 5895890000 take all the space away in list which is all ready formatted. Many thanks in advance for your help!! I look forward hearing from you soon! I´m watching your videos and I learned allot. You make it very interesting thanks
Karin16121968 11 months ago
1) If the numbers actually have spaces and the numbers were in column A, put this formula in cell B1:
=SUBSTITUTE(A1," ","")+0
and copy down. Then copy column B and paste Special-Values
2) If the numbers have a custom Number format like "000-000-00-00", then apply the General Number format to remove the Applied Format (Ctrl + 1, on Number tab click on "General" on left)
ExcelIsFun 11 months ago