Yes, I am! I've never experienced it before (don't use Currency format much) but it happens on two separate machines!
maccboy
On Friday, March 8, 2013 3:49:25 PM UTC, GS wrote:
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