In article <[EMAIL PROTECTED]>, Harold Fuchs <[EMAIL PROTECTED]> wrote: > On 24/09/2007, Neal Piche <[EMAIL PROTECTED]> wrote: > > > > I am making a spreadsheet for a list of previous addresses, I used > > spreadsheet cause I needed to show the length of time at the address > > given move in and move out dates. When I enter a phone number as > > 8005555555 I want it to automatically format it as (800)555-5555. I know > > that microsoft office can do this, please someone tell me how to do it > > in openoffice :) > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED]
> Use Format Cells to format the *numbers* as "(000)000-0000" (without the > quotes0> > So: select the cells/column/row and then > Format>Cells>User-defined; enter "(000)000-0000" (no quotes) into the > "Format code" box and click OK. As a matter of interest, (###)###-#### also seems to work! R. -- Richard Travers [EMAIL PROTECTED] Truro, Cornwall --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
