![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
![]() |
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 |
![]() |
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 |