Formatting a integer variable or something...

I'm trying to format a number inside of a chain of a string. So,

Worksheets("TASK").Cells(task_sht_current_row, task_sht_act_id_column) = Cells(current_act_row, work_package_column) & "-" & Cells(current_act_row, cti_wp_column) & "-" & current_act_step_num

So I'm trying to format the last variable so that it is always four digits, ie, 0001, 0034, 0204, 1234, etc...

Any clue how to do this, I've searched around and can't seem to find the code for it. I could do it with a long set of conditional statements, but I'm pretty sure there is a format function or something. Thank you.

Use Format(current_act_step_num,"0000")

TJ

So I put that line in,

... = Cells(current_act_row, work_package_column) & "-" & Cells(current_act_row, cti_wp_column) & "-" & Format(current_act_step_number, "0000")

And I'm not getting any errors, but that part of the chain isn't showing up. at all.

DR0411-TK00-

Where is should be,

DR0411-TK00-XXXX

I can only get that if the variable is declared as Variant and is empty.

How have you declared current_act_step_number and are you sure it has a value?

TJ

Nevermind,

I had a typo.

num vs. number

Option Explicit