Split 123.54

[Johnmcenroy]

Hello
Sorry for this simple question. I looked at ceil , floor , round but i need only this:
I have a number 123.54 for example , how can i divide it into two parts:
123 and 54 ?

Thanks

 

[NJDude]

Something like this:

Dim Number As Double
Dim Buffer() As String

Number = 123.54

Buffer = Regex.Split("\.", Number)

Msgbox("Integer =" & Buffer(0) & CRLF & "Decimal =" & Buffer(1), "")

 

[Johnmcenroy]

Something like this:

Dim Number As Double
Dim Buffer() As String

Number = 123.54

Buffer = Regex.Split("\.", Number)

Msgbox("Integer =" & Buffer(0) & CRLF & "Decimal =" & Buffer(1), "")

Thank you very much

 

[Johnmcenroy]

All Works. Only when I type for example 5.10 I see 5 and 1 , and I need 5 and 10 . Why it is happened so ?

Thanks

 

[NJDude]

Take a look at NumberFormat

 

[Johnmcenroy]

I have a Sub:

ImperialMetric (Imperial As Double,Name As String) As Double

When I write ImperialMetric (5.10,"test") i get 5.1 inside my sub.
How can i achieve 5.10 inside sub ?

 

[NJDude]

Check the attached sample.