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 <b.m.bar...@btinternet.com.invalid> > 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: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
