View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default Zip + 4 format column then must double click to change - why?

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