Number from text

**zbor** · 03-27-2009, 09:21 AM

Nope

Can you look here.. different problem... same workbook... (sheet 1, G)

http://www.excelforum.com/excel-gene...ml#post2066157

**NBVC** · 03-27-2009, 09:25 AM

I don't see anything that looks like what you are describing above.

**DonkeyOte** · 03-27-2009, 09:27 AM

Looks like CHAR(160) ...

=0+SUBSTITUTE(cell reference,CHAR(160),"")

**NBVC** · 03-27-2009, 09:32 AM

Originally Posted by DonkeyOte

Looks like CHAR(160) ...

=0+SUBSTITUTE(cell reference,CHAR(160),"")

Where did you see that?

**DonkeyOte** · 03-27-2009, 09:33 AM

From the file zbor had uploaded to the other thread he/she referenced in post # 5

**NBVC** · 03-27-2009, 09:35 AM

Originally Posted by DonkeyOte

From the file zbor had uploaded to the other thread he/she referenced in post # 5

Yes, I know.. but I didn't see the cells in column G that had those numbers... maybe I am blind.

Re: Number from text