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

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

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

Yes! I've never seen it before but I don't use Currency format much. It happens on two separate machines too.
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

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

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

On Monday, March 11, 2013 2:28:59 PM UTC, GS wrote:
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