View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Rhein Michael Rhein is offline
external usenet poster
 
Posts: 4
Default HELP - weird Negative Numbers

Newbie questions :
I am currently working with some output report from my company
database in *.txt format. After converting to *.xls, i got the
negative records shows negative sign AFTER the number (example : 254
-) instead of before the number like it normally does.

Let say the number is in cell B1. So I use :
=IF(RIGHT(B1,1)="-",LEFT(B1,(LENB1)-1)))*-1,B1) to make it right.

Is there any simpler way rather than having some conditions ?

TIA
michael