When I do : #NumberFormat(MyVar)#
It gives an error that myVar is not a number.... but I selected it from an
int id feild.
Is there any way of testing for the format of a variable?
Thanks
Ben
----- Original Message -----
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 11:33 AM
Subject: RE: Reformatting number
> >
> > hi,
> >
> > I've got a number in the form of 16,511.00
> > I'd like to convert it to just 16511
> > As SQL doesn't seem to like it in the first format, even though
> > I'm getting
> > the number from SQL in that format.
> >
>
> Morning Ben,
>
> The function you're after is NumberFormat.
>
> Regards
>
> Stephen
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
