Excel Forum
Similar Content
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Get the Integer Part of a Number in Excel
Tutorial: How to get the integer part, the whole number, from a number that has a decimal after it. ...



Excel Magic Trick #141 part 1: Day Numbers to Dates


See how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date. =DATE(2008,11,1) will put the date 11/1/2008 in a cell.





Got a Question? Ask it Here in the Forum.