Brian, It does drop a leading zero in the area code. It doesn’t drop leading zeros from the prefix series or the exchange series. In the USA no area code starts with a zero so this would be a nonissue.
Steve Sent from my iPhone > On Feb 24, 2022, at 9:44 AM, Brian Barker <[email protected]> > wrote: > > At 09:18 24/02/2022 -0600, Steven Ahlers wrote: >> If you want the format of 1 (123) 456-7890 simply type in the format >> definition box (near the bottom of the pop up menu for Format Cell under the >> Numbers tab) 1^(###)^###-#### (where ^ is a space). > > But that format will (inappropriately) lose leading zeroes in any of the > three groups - which can certainly occur in the final group. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
