Thank you Sandy your suggestion work perfectly. Question, why do both
converted and non-converted cells show up as general when I look at how they
are formatted?
Also thank you Chip & Dominicb, for helping.

JTH

--
Access is my work in progress


"Sandy Mann" wrote:

JTH,

That wasn't in this NG it was in the 'excel.newusers NG. Chip & Dominicb
were suggesting that the 'Numbers' may be text. Try copying a blank unused
cell and the highlighting the 'numbers' that you want to change then
selecting Paste Special Add. This should change the text number into a
real number.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"JTH" wrote in message
...
I had posted a question titled "sort numbers" late Friday. And I have still
not solved my problem. Would anyone be willing to take a look at the file
and
see what if they can work with it?
I look forward to any possible ideas.
Thank you,
JTH
--
Access is my work in progress