Stop rounding!

[hallingh]

Excel is rounding dollar figures on my sheet to the nearest dollar, but I don't want it to do this. After looking at the formatting I don't really see why it is rounding, but I'm sure I'm missing something.

How do I get Excel to leave the cents in my cells and not round?

Thanks!

Hank

 

[kpark91]

Try

$#,##0.00_);[Red]($#,##0.00)

onto your custom cell formatting.

 

[hallingh]

That's what I had it set to previously, which I thought would make it not round, but it is still rounding to the nearest dollar.

 

[kpark91]

Did you do any calculations before getting the output?
or did you type in the data yourself and it's displaying it as whole numbers?

 

[number kruncher]

Is this 'rounding' happening on one or more workbook(s)?

 

[hallingh]

Ahhhh there's the problem. I'm adding two numbers together using vba to populate the cell. When I just type the number in it does not round it. How do I format the vba code to make it not round??? Thanks for the help.

 

[JamesW]

Hi,

Try storing the variable as a double, rather than an integer.

 

[kpark91]

Well. When you're populating a cell with VBA
in order for it to be not integers, you need to make sure the variables you're adding up are not integers
So you could just set them as Double or Float (not too sure in VBA tho)

So let's say you want to add x and y

Dim x, y as Double
Sheet1.Range("A1").Value = x + y

should do the trick.

 

[hallingh]

That worked perfectly. Thanks a ton for the help; I was stumped!

Hank