Another Simple Question

[tphillips]

How do I format a cell name in code to drop the digits after a decimal. For example, I want the value of A1 to display with no decimals. But I need to do it in code. Thanks

 

[lenze]

Why do you need code?

Format>Cells>Number Tab Custom Type = ###

This will round the number to the nearest whole number. If you always want to round down, see the ROUNDDOWN funtion. There are also other funtions the work as well or better for this.

lenze

 

[Joe4]

    MsgBox Format(Range("A1"), "0")

Of course, you can also set it equal to a variable instead of displaying it in a Message Box.