I really meant Format, as in:
Msgbox Format(1234.34,"$#,0.00")
msgbox format(now,"yyyy_mm_dd__hh:mm:ss")



Dennis wrote:

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

--

Dave Peterson