Macro acting wierd with Zip Codes
 

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:

<BCells(1,15) = "06555"</B

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

Macro acting wierd with Zip Codes
 

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

note added single quote.

--
Regards,
Tom Ogilvy


"Stick With Hair" wrote:

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:

<BCells(1,15) = "06555"</B

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

Macro acting wierd with Zip Codes
 

Another:

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

Stick With Hair wrote:

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:

<BCells(1,15) = "06555"</B

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

--

Dave Peterson