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. For further options see the Help under "Number formats". -- Harold Fuchs London, England Please reply *only* to [email protected]
