Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-24-2020, 02:47 PM
PomDave PomDave is offline Cell formula error? Windows Vista Cell formula error? Office 2010 32bit
Advanced Beginner
Cell formula error?
 
Join Date: Sep 2011
Location: Australia
Posts: 47
PomDave is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP Formula error but WHY??? Haga Excel 1 04-17-2019 11:13 PM
Cell formula error? 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
Cell formula error? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft