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