Almost. Try Right ( "0" & number ; 2 )
------------------------------------------------
Steve Hearn
:: FileMaker 9 Certified Developer ::
FileMaker Technologies Team Leader
CoreSolutions Development Inc.
Web Site:
http://www.coresolutions.caLondon: (519) 641-7727 - Toronto: (416) 410-8649
------------------------------------------------
software that works for you
> From: Lorne & Joan Walton <
walton@...>
> Reply-To: <
fmpexperts@...>
> Date: Wed, 19 Nov 2008 11:31:34 -0800
> To: <
fmpexperts@...>
> Subject: Re: Forcing leading zeros
>
> Make it a text field, Right ( number & "0" ; 2 )
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au