Currency autofit

[maccboy]

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

 

[GS]

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

 

[andy.bayley]

Yes, I am! I've never experienced it before (don't use Currency format much) but it happens on two separate machines!
maccboy

 

[maccboy]

Yes! I've never seen it before but I don't use Currency format much. It happens on two separate machines too.
maccboy

 

[GS]

Yes! I've never seen it before but I don't use Currency format much.

It happens on two separate machines too.
maccboy

Interesting! When I enter long digits the col width auto-adjusts in my
version of XL2000 Pro! Mind you, I only set A1:B1 to Currency style and
not entire columns. (Not that it should make any difference, unless
it's resource related)

--
Garry

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

 

[maccboy]

I've discovered that it appears to be due to the fact that there is conditional formatting on those cells (along with others). I've set CF on the whole sheet and it highlights and borders any row where the text in column B is"Total". I've tried to recreate it outside the macro and I can't so there must be more to it than that.
maccboy