Skip to main content
0 online
forrestina Jun 28, 2007

help! anyone good with mail merges from excel to word?? i can't get the starting zero in the zip codes to show up.

originalsnob originalsnobOG 2004

right click on the cell... choose format cell select "special" and there's a choice that says zip code click it, it should then display normally =)

forrestina forrestinaOG 2002

i know it works in excel, but doesn't carry the zero over in the word merge. i had to revert to an older version of excel and format the cells as text.

Welcome Back to eZabel

It's been a while. Here's what's new.

eZabel Lore

A complete history of our community — stats, Hall of Fame, legendary threads, and more.

View the Lore →

Everything Preserved

All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.

💎

Gems

Spot something you love — a legendary comment, a classic thread, a great photo? Log in and click the diamond icon to mark it as a Gem. Add a note about why it's special. The best stuff surfaces on the Gems page.