Zip + 4 format column then must double click to change - why?
My column contains both five digit and nine digit zip codes so your method
doesn't work on both of them. Thanks for trying.
dm
"James Silverton" wrote:
Hello, dm!
You wrote on Mon, 11 Sep 2006 12:55:02 -0700:
d When I format a column to be zip + 4 or phone numbers, I
d must first double-click the cell(s) then press enter for the
d change to show up. Why?
Is that so? I just tried an experiment and set a column of 9
digit numbers to be formatted as Zip +4. The cells changed
immediately.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
|