Use the number as a *string* and append the zeroes on the left on side based on the number of zeroes required. On Sat, Feb 6, 2010 at 10:46 PM, Brett <[email protected]> wrote:
> I am new to VB and was hoping someone could help me. I would like > to know how I can format a number field. For example my field is > called "Amount" and is currently formated like 592.35, I would like > to > display the "Amount" field as "000000000059235". > > > I was trying to use Format(Amount,"000000000000000") but no joy. > > Thanks. > -- Thanks and Regards Sreekanth Dora Bhogoju
