I would like to enter number as text in Excel without using single quotes. Any help on this pls?

To be very clear, I just need something equivalent to Excel --> Format --> Cell --> Category --> Text (Select Text from list)

Example

I currently have
xlSheet.Cells(1, 1).Value = ("01012004")

I don't want like this
xlSheet.Cells(1, 1).Value = ("'01012004") 'Single quote before 0

Thanks