Seperating digits from a number [excel formulas]
Reader Joann asks through email:
Take the number 117490. I need to break it down5 times:
You can use FLOOR() function to get the desired result, like this:
See the image below:
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Is your (chart’s) underwear showing?||5 Visualizations for Your Inspiration [Nov 14] »|