convert text cell to numeric cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
convert text cell to numeric cell

FAQ

Thread Tools

Display Modes

08-19-2015, 09:59 AM

mikec

Windows XP convert text cell to numeric cell

Office 2010 32bit

Advanced Beginner

Join Date: Nov 2012

Posts: 30

convert text cell to numeric cell

I exported a table from a website to excel. One of the columns which contained money values i.e. £30.09 was entered into excel as a text value. TYPE(cell address) returns 2. I want to SUM this column but SUM ignores text values and so SUM returns 0.00. I created a new column with =RIGHT(old column,LEN(old column)-1) which got rid of the "£" but the new column was still TYPE 2 non-numeric. Is there a way of changing cell type programatically?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert non-cell input to cell values	TBD	Excel	3	06-09-2014 06:14 AM
Table with text that flows from cell to cell	hwrigley	Word Tables	7	02-18-2014 02:59 AM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM
How to input the text of a cell into another cell automatically ？	Juliet	Excel	1	03-15-2013 03:25 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.