#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
try multiplying that formula by 1
programmatically.... search the VBA help file for Conversion Keyword Summary |
#3
|
|||
|
|||
convert text cell to numeric cell
I tried your *1 but it failed. I decided to recheck and found that my conversion formula had left a leading space in the string and that was the cause of my problem. Your *1 worked then as of course did VALUE(cell address) as will the VAL function of VBA. Apologies for wasting your time.
Also thanks for the useful lead into the VBA help topic. |
|
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 |