Adding Two Cell Values to Include Comma Separator

[phoenixsuun]

I have a spreadsheet with two values that need to be added and printed. I currently have this:

myVar = Range("C8").Value + Range("S8").Value

This code adds the values together but when I print myVar, there is no comma. How can I make sure there is a comma in my numbers?

Example: 1,000 + 50 = 1,050 NOT 1050

 

[Joe4]

Welcome to the Board!

Number variables do not have any formatting, only values. You need to apply the format either in to cell (if returning it in a cell), or in the MsgBox you return (if returning it to the screen), i.e.

    myVar = Range("C8").Value + Range("S8").Value
    MsgBox Format(myVar, "#,##0")

You could also store the variable as text, but then you would not be able to use it in mathematical calculations.

 

[phoenixsuun]

Welcome to the Board!

Number variables do not have any formatting, only values. You need to apply the format either in to cell (if returning it in a cell), or in the MsgBox you return (if returning it to the screen), i.e.

    myVar = Range("C8").Value + Range("S8").Value
    MsgBox Format(myVar, "#,##0")

You could also store the variable as text, but then you would not be able to use it in mathematical calculations.

Thanks @Joe4! That did the trick. I ended up with a statement that looks like this:

Print #1, "<div>There are: " & Format(myVar, "#,##0") & " animals located here.</div>"

 

[Joe4]

You are welcome!

Glad I was able to help.