|
|
#3
08-05-2012, 05:08 PM
|
||||
|
||||
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] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel 2007 cell format help!!!
|
Raner | Excel | 4 | 06-17-2013 11:13 PM |
| Cell format not staying | vijer | Excel | 3 | 01-12-2012 07:06 PM |
| Cell # format | markg2 | Excel | 4 | 10-23-2011 09:38 PM |
| Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode