View Single Post
 
Old 08-05-2012, 05:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

How about =A1 with the number format specified as:
000 000 0000
Indeed, if you specify that number format for A1, you don't even need B1!!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote