Number Conversion Problem - 2 dec places

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi.

How can I convert a number which has 3 or 4 decimal places into one with
only 2 decimal places

From: 20.1354
To: 20.13

I would like to insert it into a table via an insert query and the
FormatCurrency$(x,2) doesn't get accepted by the table
it includes the ? sign

Gina
 
Hi.

How can I convert a number which has 3 or 4 decimal places into one with
only 2 decimal places

From: 20.1354
To: 20.13

I would like to insert it into a table via an insert query and the
FormatCurrency$(x,2) doesn't get accepted by the table
it includes the ? sign

Gina
Click to expand...



Dim MyNum As String
MyNum = "345.2369"
Debug.Print Format(MyNum, "###0.00")

Produces: 345.24

HTH,
RD
 
Hi.

How can I convert a number which has 3 or 4 decimal places into one with
only 2 decimal places

From: 20.1354
To: 20.13

I would like to insert it into a table via an insert query and the
FormatCurrency$(x,2) doesn't get accepted by the table
it includes the ? sign
Click to expand...

Try

Round(x, 2)


John W. Vinson[MVP]
 
Back
Top