The problem i encountered with Custom formatting is that the content can't be displayed if the column has a width of 3.14 (the width i need).
I noticed this; even with a linefeed in the formatting (a) autowidth goes to a width as if there was no linefeed and (b) anything less than that width shows ####.
I don't know a work round for that except to use a macro/vba.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.