Number Format in VBA

[dave8]

How can I display a number as 123.45 to 123. If number is 123.50, display as 124. I just want to display whole number.

 

[lenze]

If you format your cells as Numbers and select 0 decimal places, the numbers will display as you desire!!

lenze

 

[dave8]

Thanks. But there's something else. An example of my cell looks something like this:

Cost $xxxx ----- I want to look -----> Cost $ - if no value (or zero).

In your suggestion, changing to Number format with 0, looks like this:

Cost $ 0


Note: The title 'Cost' is in cell A1 and $xxxx is in B1.

 

[lenze]

In your suggestion, changing to Number format with 0, looks like this:

Cost $ 0

Then use a Custom Format

##;-##;

Actually, with a Custom Format, you only need 1 cell

"Cost" ##;"Cost" (##);

You can use either a negative sign or parens for your negative values
If you want the dash for zero

##;-##;-

or

"Cost" ##;"Cost" (##);-

lenze

 

[dave8]

Yes, thank you.