Formatting from 0025 to 25

[warker]

Hey everyone, I have another formatting question.

I have a file that is FTPed to me daily. I use SQLLOADER to insert the data into an Oracle database. The problem is the fields are isnerted by fix width. That means that the field that contains the numbers I have are out of wacked. Here is that I need:

The number coming out of the DB is 000025000

I need to cut the leading zeros off, any help?

Thansk again...

[John McKernan]

'To include commas:
Format(number, "#,##0")
 
'no commas
Fomat(number, "###0")
 
'decimals
Format(number, "#,##0.0000###")