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
Ben


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,
Daniel.

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

Ben,

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.

Ed

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 http://www.asap-utilities.com