I'm pretty average with Excel, so there may be a not too diffictul solution to this issue, but I have turned
to a dedicated forum as I simply can't find it...
I have data I've imported into excel. One column was basically
numbers, with 5 additional characters at the end of each value. I used the LEFT command to strip those out (yay me and the
What I'm left with is the numbers. BUT, there is an issue. Every number is preceded either with a - or
a + (depending, obviously, on whether the number was negative or positive).
I'd like to just be able to do normal
calcuations etc with the numbers, but the + signs are causing obvious grief. I've tried changing the cells to number, to
text, to general etc. I also figured I could just do a search and replace, search for a + and replace with nothing, and then
convert all the cells to numbers. But that doesn't work. According to the Find item there are no +s in my spreadsheet.
I assume because the + symbol has significance excel tries to treat it differently and that is causing my issue? Is
there a way around this?
Oh, and I'm using Excel 2007...
Any help would be greatly appreciated!