View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stick With Hair Stick With Hair is offline
external usenet poster
 
Posts: 1
Default 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?