Just to be sure; I believe that you meant .FormatNumber because
Format() seems to apply to dates.

EagleOne


Dave Peterson wrote:
Take a look at Format in VBA's help. It's not exactly the same, but similar.

Dennis wrote:

2003

Is there a VBA Function for WorksheetFunction.Text?

TIA EagleOne

--

Dave Peterson