ActiveCell.Clearcontents

does exactly that - Asc(10) is not ignored.

You probably didn't apply it to the cell in question.

--
Regards,
Tom Ogilvy


"Rocky McKinley" wrote in message
...
Problem solved thanks for all the help.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
Chips Add-In comfirms as my code below did that the Decimal character is
010. It really doesn't matter what character it is as long as I can get
rid
of it, that is the main problem. I'm sure someone must have ran into
this
one before!

Any help is still appreciated.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
I used the code below to check the cell in question and the message
box
came
up with 10 as the only answer.

Sub CheckCellValue()
Dim a as Integer
For a = 1 To 255
If Chr(a) = Range("AE16").Text Then MsgBox a
Next a
End Sub

I'll check out Chip's page as you suggested, thanks.
--
Regards,
Rocky McKinley


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Rocky

How do you know the character is asc(10)?

Maybe asc(13) or some other.

Check out Chip Pearson's Cellview add-in to see what you have in the
cell(s)

http://www.cpearson.com/excel/CellView.htm

Gord Dibben Excel MVP

On Fri, 11 Jun 2004 16:04:32 -0700, "Rocky McKinley"
wrote:

Unfortunatley that didn't work, thanks for the try though.