The root of this is that Excel's percentage format defaults to 2 decimal
places. From what Nick says, there seems to be a mixture of number formats
in his columns which makes a 'blanket' format change inappropriate. The only
way I can see of avoiding a lengthy cell-by-cell format is to have each format
in its own column and apply formatting column-by-column.
I had a macro before for setting formats, but now I need to format
them from Access for some calculations to take place. The problem with
the macro was that the formatting I need is more cell format. I tried
to apply row & column format but sometimes some cells had wrong
format. Formatting cell by cell is very slow.
I tried format>style but is strict, if you enter a number it applies
in any cell that formatting is applied, while in some cells I may need
to have numbers without percentage and without decimals, in some
others I may need decimals etc.
--
John Thow
an optimist is a guy/ that has never had/ much experience -
certain maxims of archie; Don Marquis.
To e-mail me, replace the DOTs in the Reply-To: address with dots!