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

Text to Number
 

09571663-1 is not a number so you would first have to decide what number
you want to convert it to eg 95716631.

Regards
Rowan

Lift Off wrote:
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