Excel Magic Trick #503: Custom Number Format For Turnover Ratio

[Karin16121968]

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!!

[ExcelIsFun]

You are welcome! If you like the video, I just published my forst book:

"Slaying Excel Dragons". You can get it at Amazon!

[Karin16121968]

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

[ExcelIsFun]

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)

[kjaan1]

Very neat trick...didn't know about adding comments after custom setup.