I faced some problem to format text in the MSHFlexGrid. Here is the code I put

MSHFlexGrid2.Col = 6
MSHFlexGrid2.Text = Format(MSHFlexGrid2.Text, "dd/mm/yyyy")

It only format first row of the column 6, what code should I put to format whole columns?

Another question is how to format the work order number and week code?

Work Order 168(computer output) --> 00168 (required output)
Week Code 21 --> 0021