A column in a spreadsheet contains date of birth info such as these:
When I tried formatting to mm/dd/yyyy some of the rows appeared as ######
I then checked 1904 date system box under Options\Calculation . Still same problem
All I want is to add / to the dates so they appeared as mm/dd/yyyy
I've spent 3 hours on these already.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…