Hey guys and gals,
I have an Excel document for working through many financial numbers, and the matter what I do, I can't convert a text string like "60.00" to a number using the fx '=VALUE(cell number)'. I always get back a '#VALUE!' Error.
I've checked for spaces and checked for symbols using 'Find and Replace'. And I've done what I can to get it to be a number, but I always get a value error. I've also checked that the text is, in fact, a string by =ISTEXT(), and it says TRUE, so I'm a little confused.
I've attached the text strings I'm trying to convert to numbers; this is only a small sample of the hundreds I have to do.
Any help you can give a noobie Excel user? I really appreciate any help you can provide.
Bookmarks