|
|
#1
10-24-2020, 02:47 PM
|
|||
|
|||
Cell formula error?
Hi All, I'm following the Covid numbers from virusncov.com and copying their data into my own sheet for analysis. One of the columns has figures like +43,852+0.5% Unfortunately Excel doesn't recognize this and will not place a single figure in the cell. Is there away of changing the starting + to an = sign, thus making it a number. Best Rgds, Dave Robinson 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
 Entering a column value in a cell, to be used as part of a reference in a formula in another cell
|
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
| Error handling in formula - suppress 'Syntax Error' | Cosmo | Word | 7 | 02-24-2014 07:08 AM |
|
Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Windows Vista 
Office 2010 32bit
Threaded Mode