format variable

  1. K

    Format Month Number Variable as mm ?

    I am writing a script that will save files to a new monthly directory for 3 months in advance. Directory naming convention is this: 04-April 2020 I can get the year and I can get the month name. I can get the month number to return 4, but I need 04. FY = Year(Date) FM =...
  2. 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...
  3. 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

Top