What's wrong with this formula?

J

JHL

I'm using Excel97. When you look up the built in help for the LEFT
function, at the bottom it explains that you can use this and the LEN
function to correct numbers posted like this 8.41- to this -8.41.

When I copy the formula and paste into my spreadsheet, adjusting A2 for my
actual cell references, the formula doesn't work. What gives? The formula
is: LEFT(A2,LEN(A2)-1)*-1

Is it something with copying the formula from the help page?

Thanks for any help.
 
D

Dave Peterson

My guess is that there's nothing wrong with the formula (besides the missing
leading equal sign).

What's in A2?

Try typing it it once more (manually).

Maybe you got extra spaces (or those HTML non-breaking spaces) in A2????
 
P

Peo Sjoblom

When you say doesn't work, what happens?
It works for me

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top