Gents,
I have a Userform with about 160 labels. the label
captions are linked to the cells in the worksheet. the
cells have numeric values in them.

although i can get the userform to display each label
individually in number format.

I would like to know if there was a easy way to do this,
instead of writing 160 lines to show the format i want.

below is a format i have for each label
Label1.Caption = Format(Label1.Caption, "#,##0.00")
this is the common format i have for all the labels

thanks.....Edgar