format variable

  1. F

    How to format array variables back to spreadsheet?

    Hi, I have a userform where the user will register types of steel and their chemical composition. I am having issues formatting the data from the userform back into the spreadsheet to be saved. When I populate the cells, they are put as text and not numbers, they must be defined as numbers on...
  2. B

    Format decimal place for variable

    I have declared a variable 'Z' in a procedure I am running, I want it to be displayed in a MsgBox with as a percentage with two decimal places. The code I have is: Dim Z As Variant MsgBox "The Homogeneity of the Batch Model is:" & vbCrLf & vbCrLf & _ " " & Z &...

Some videos you may like

This Week's Hot Topics