Simple but I can't remember

[Andibevan]

I know this is really forgetful of me but I can't find out what the correct
data type for normal decimal numbers would be e.g. 21.45 or 123.45?

TIA

Andi

 

[Bob Phillips]

Double.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Andibevan]

How do I format something to have 2 decimal places?

The following returns 12.1 not 12.10

Dim lNewRev As Double
lNewRev = 12.1
lNewRev = Format(lNewRev, "###0.00")
Debug.Print lNewRev

 

[Dave Peterson]

It sounds like you want to display the value formatted to two decimal places:

Dim lNewRev As Double
Dim lNewRevStr as String
lNewRev = 12.1
lNewRevStr = Format(lNewRev, "###0.00")
Debug.Print lNewRevStr

'or just
debug.print Format(lNewRev, "###0.00")

 

[Bob Phillips]

That is because Format returns a string, but you are still using the double.

Try

Dim lNewRev As Double
Dim sFormat As String

lNewRev = 12.1
sFormat = Format(lNewRev, "###0.00")
Debug.Print sFormat

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)