Turn Off Rounding In Excel And Use The TRUNC Function – Formula Friday
Hello, welcome to another #formulafriday blog post for some more formula fun on a Friday - why not?. Today let's take a look and explore the issue of Excel rounding or not rounding numbers. You...
Why Is My Formula Not Auto- Completing When I Type The Equals =Sign – Formula Friday
Hello Excellers, and welcome to another #formulafriday blog post. I want to share with you an issue one of my subscribers had. Their Excel was not behaving as 'normal'. When they began to...
Generate A List Of Files In A Folder – Without Macros or VBA Code – Formula Friday
Hello, Excellers have you come here for some more #formulafriday fun. Good. Me too!. Today let's look at a really cool way to generate a list of files in a folder without any macros, coding or VBA...
Excel Tip – Insert The Contents Of A Cell Into A Text String – Formula Friday
Welcome back to another Excel #formulafriday blog. Today I want to share with you a nice handy Excel tip using a well-known formula. Let's learn how to insert the contents of an Excel cell into a...
Hello and welcome back for some more #formulafriday formula fun. Today let's look at how to calculate the exact dates that your excel reports are due. We can do this with two formulas. The...
Hello Excellers. I have decided to go Back To Basics today for today's #formulafriday blog post and take a look at relative and absolute references in Excel. Why would I do that?. Well, a...