convert currency to string

's Computer Specifications

AMOUNT: CStr([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed])

How do I convert $45.50 to "45.50" ...?
No matter what I do I keep dropping the zero to "45.5"

thanks!

's Computer Specifications

Hello.

"shank"
> AMOUNT: CStr([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed])
>
> How do I convert $45.50 to "45.50" ...?
> No matter what I do I keep dropping the zero to "45.5"

AMOUNT: Format([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed],"0.00")

--
Regards,
Wolfgang

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Currency to String but keep commas	Don	Microsoft Access Queries	2	2nd Apr 2010 10:43 PM
Convert currency formated string back into decimal	=?Utf-8?B?R3JlZyBH?=	Microsoft ASP .NET	1	3rd Nov 2007 04:48 PM
Convert Currency-formatted string back to decimal	Ritu.Chandra.JBS@gmail.com	Microsoft ASP .NET	2	4th May 2006 02:14 PM
Convert a currency string to a double	R. John Reed	Microsoft C# .NET	0	13th Apr 2005 04:36 PM
Best way to convert back a currency string into a number(int or long)?	Juan	Microsoft Dot NET	2	25th Oct 2004 12:52 PM