Dennis Faas's picture

Switch Between Date and Serial Values in MS Excel

MS Excel formats date and time values in a way that is meaningful to us, such as 12/01/08; December 1, 2008, 2:15 p.m., 12/01/08, 14:15, etc. With just a quick glance, we know precisely what the date and time string represents, but internally MS ... Excel uses a serial value, not the formatted value that we see. When working with time and date values, it can be very beneficial to know the serial value and Excel makes it easy for us to have a quick look and see. Follow the steps below to learn how: Enter some date and time values: Click CTRL + ; to enter the current date. Click CTRL + Shift + ; to ... (view more)

Dennis Faas's picture

Converting Dates in MS Excel

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

Subscribe to RSS - values