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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
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 |