![]() Press ENTER, and the DATEVALUE function returns the serial number of the date that is represented by the text date.Įxcel stores dates as sequential serial numbers so that they can be used in calculations. Select a blank cell and verify that its number format is General.Ĭlick the cell that contains the text-formatted date that you want to convert. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them. To convert a text date in a cell to a serial number, use the DATEVALUE function.
0 Comments
Leave a Reply. |