Simple String Conversion - HELP

[prepotency]

Anyone know off-hand the command to convert a number:

0000000456

to:

4.56

I tried this:
Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2

Which works, but not if you're copying the data from another workbook.

Any ideas?


Garrett (MIS)

[Kaak]

Dim TempNumber as single

TempNumber = "000000456"

TempNumber = TempNumber / 100

[mangesh_yadav]

=VALUE(A1)

where A1 has your number 000456

Mangesh

[mangesh_yadav]

in VBA simply do:
a = Int( "0000456")

Mangesh

[prepotency]

hahahaha wow - didn't even occur to me to divide by 100. That makes me laugh.

Here's something else I came up with if anyone needs it later:

Sub insertDecimal()

Dim theInput As String
theInput = "0000000875"
Dim leftText, rightText As String

leftText = left(theInput, Len(theInput) - 2)
rightText = right(theInput, 2)

Dim newText

newText = leftText + "." + rightText

Cells(1, 1).Value = newText



End Sub


thanks for the replies all