Formatting Numbers (1 Viewer)

xDamian

New member
Local time
Today, 13:17
Joined
Feb 12, 2004
Messages
8
Hi

Is there a simple way to display numbers entered as 3-digits - eg 007?

My user has an invoice reference which consists of a pre-fix (eg 'INV') and then an automatically generated number (eg 7).

Rather than the invoice reference be displayed as 'INV-7', they would prefer see it as 'INV-007'.

Grateful for any solutions / advice.

Cheers

D:cool:
 

saintsman

Registered User.
Local time
Today, 13:17
Joined
Oct 12, 2001
Messages
138
In the field's properties put 000 in the "format" line.
 

xDamian

New member
Local time
Today, 13:17
Joined
Feb 12, 2004
Messages
8
Thanks - that worked a treat!:)
 

Users who are viewing this thread

Top Bottom