Thats right, i've just run it, one column as number format, run the code and get the same values, but in General format

you could prefix with a "'" or use the worksheetfunction.text() approach?