MrExcel Publishing
Your One Stop for Excel Tips & Solutions

My numbers are text!

Posted by Ben on October 04, 2001 2:05 AM

I'm sure there is a simple answer but i'm stuck and need your help.
Some cells of my spreadsheet contain numbers/date, but they appear as text. How do i convert them into proper numers/dates.
i.e A1 contains 01/08 which excel takes as text. I actually want it to be a date stamp.
Thanks for any help

Posted by Dank on October 04, 2001 3:26 AM

Well as for the dates use the formula =DATEVALUE(A1) to convert a string to a date. You can then format this in any date format you want. You can convert text 'numbers' by using =VALUE(A2).

Hope it helps,

Posted by Ed on October 04, 2001 3:27 AM


Not sure if this will help but, when I import numbers from an Access Database they also come in as text. What I need to do is place the number 1 anywhere on the sheet, right click on the number 1, select Copy. Hightlight the column that is supposed to be numbers and not text, right click and do a Paste Special/Multiply. This turns all the number cells back to how they should be. It also leaves the text cells as text. Hope this helps.


Posted by Amanda on October 04, 2001 4:01 AM

Posted by Amanda Pitter on October 04, 2001 4:04 AM

Another way to do this is, highlight the column then Data / Text to Columns, select Fixed Width, [Next] [Next] and then in the Column Data Format select the Date as DMY

Posted by Bastien on October 04, 2001 12:41 PM

Hello Ben,

My add-in ASAP Utilities has a quick tool to convert all "text" numbers to real numbers.
It's free and available at