Macro acting wierd with Zip Codes

[Stick With Hair]

I'm trying to store zip codes in a spreadsheet but am getting issues
with items that start with a 0.

The code I am using is:

<B>Cells(1,15) = "06555"</B>

The end result is showing up as 6555 in Excel - how do I get it to
show 06555?

 

[Guest]

<B>Cells(1,15) = "'06555"</B>

note added single quote.

 

[Dave Peterson]

Another:

With activesheet.cells(1,15)
.numberformat = "@" 'text
.value = "06555"
End with