Formating Number's

[CmPaiva]

Hi all,

Is there a way of formating real numbers to have leading zeros, as in VB Format function?

ie: Format(123.456,"000000.00&quot => "000123.46"

Thanks in Advance for your time,
Carlos

 

[mimi2]

I did a search on this site on "leading zero"
you might find interesting things in these links:
thread183-661696

 

[CmPaiva]

Thanks, mimi2, It help. I did my own FormatNr Function to do the job.

Carlos