You are not logged in.

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

newser-sky

Beginner

  • "newser-sky" started this thread

Posts: 1

Date of registration: Mar 15th 2011

  • Send private message

1

Friday, March 18th 2011, 11:01am

formating numbers and decimals

we are from italy we need to know how format numbers with decimal.

thanks a lot

A1880

Intermediate

  • "A1880" is male

Posts: 500

Date of registration: Jan 1st 2009

Location: Hanover, Germany

Occupation: Software Engineer

Hobbies: Hilbert Curves

  • Send private message

2

Friday, March 18th 2011, 2:15pm

Jabaco's implementation of Format() is not fully compatible to the VB6 format.

You can use your own formatting function from the Java API as follows:

Jabaco Source

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14

Option Explicit

Public Sub Command1_Click()
      Debug.Print "1.414 " & nformat(1.414, "#.#")
      Debug.Print "0.99 " & nformat(0.9937, "##.0###%")      
End Sub


Public Function nformat(value As Double, Format As String) As String
   '  see http://download.oracle.com/javase/6/docs/api/java/text/DecimalFormat.html
   Dim df As New java#text#DecimalFormat(Format)
   
   nformat = df.format(value)
End Function


The format strings are described here.

Greetings

A1880

Similar threads

Rate this thread
WoltLab Burning Board