Originally Posted by
Elkar
Here's one possible solution.
Insert a new column and use the following formula:
=IF(RIGHT(A1,1)="-",VALUE("-"&SUBSTITUTE(A1,"-","")),A1)
This will move the - sign to the front of all values if they have it,
otherwise leave the value as is.
You can then perform your SUM on this new column, or "COPY" and "PASTE
SPECIAL - VALUES" over your original data. Then delete the new column.
HTH,
Elkar
"Adam" wrote:
>
>
> I copy data into excel from an accounts programme, but all the minus signs
> are at the back so Excel won't add these numbers up
>
> i.e 4
> 3-
>
> Th answer comes to 4 rather than one , what can I do about this?
>
> Thanks for your help Adam
>
> I know you guys/girls know an answer
Bookmarks