|
|
#1
08-19-2015, 09:59 AM
|
|||
|
|||
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? 
|
|
|
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 |
Windows XP 
Office 2010 32bit
Threaded Mode