Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some macro codes | Excel Discussion (Misc queries) | |||
Macro acting on all Sheets | Excel Programming | |||
ListBox/ComboBox Acting as Macro/Hyperlink Tool | Excel Programming | |||
Arrow Keys Acting Wierd | Excel Discussion (Misc queries) | |||
Macro (Codes) | Excel Programming |