Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have the number 0 in cell O3 of my workksheet. I am trying to place that number into another cell in another workbook using the following VBA line of code. I wish for the number to take on the format of ##### in this cell. So the result for O3 = 0 would be "00000" in the destination cell. This line of code isn't formatting the value, it's displaying as simply 0.
Code:
.Range("J" & drow) = Format(ws_form.Range("O3"), "00000")