mrmcg,

=TEXT(A1,"0.00") is my preferred method here.

In hopes to be helpful it is a good idea to understand what you need to change to get the correct result. When you change the formatting (i.e. number, decimal, general) you are only changing the way the data appears, not the actual data.

You will need to use a formula like round, floor, text to change the actual data.

good luck and I hope that this is helpful!

Another way is to use FIXED function, you can specify the number of decimal places but it defaults to 2 if the places aren't specified, i.e.

=FIXED(E5,2)

or just

=FIXED(E5)

Change Dim fuel As Long -> Dim fuel As Double

And both of your formula will work.

Dim fuel As Double
Dim linecount2 As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")


linecount2 = 2

fuel = Format(ws.Cells(linecount2, 2), "0.00")
fuel = Round(ws.Cells(linecount2, 2), 2)
fuel = WorksheetFunction.Round(ws.Cells(linecount2, 2), 2) '@suggested by T.M.


MsgBox "try"

End Sub

• Dim Long is for Integers (whole numbers)
• Dim Double is for numbers with decimal points (can store more decimal points, up to 15 digits)
• Dim Single is for numbers with decimal points (store less decimal points, up to 7 digits)