After serious thinking maccboy wrote :
Hi

I'm using Excel 2000 (yes, I know) and when cells are formatted to
Currency (with a £ sign at the beginning) the autofit doesn't work. I
end up with ##### in the cells. It seems that Excel is autofitting to
the biggest number rather than the biggest number with a £ at the
beginning. Has anyone seen this before and, more importantly, is
there an easy way round it? I need it to work correctly for a macro
I'm writing. Thanks. maccboy

Are you saying that Double-clicking the column's right border doesn't
work?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion