Thread: Text to Number
View Single Post
  #1   Report Post  
Lift Off
 
Posts: n/a
Default Text to Number


I have a report downloaded into Excel. The invoice numbers show as text
string, left justified, like: '09571663-1. I need to have them show up
in number format. I've tried custom formating without success. Any
suggestion how to accomplish this.

Thanks


--
Lift Off
------------------------------------------------------------------------
Lift Off's Profile: http://www.excelforum.com/member.php...fo&userid=8249
View this thread: http://www.excelforum.com/showthread...hreadid=481020