Forgot to include the OP.
Anthony Chilco wrote:
Hi Jörgen,
Here is one method:
1) Assuming that the phone numbers are in column 'P' and column 'R' is
empty, enter into cell R1:
="0"&P1
2) Select cells R1 down to the last used row (R1 - R2600).
3) Select 'edit / fill down'.
4) Select 'edit / copy'.
5) Go to cell P1.
6) Select 'edit / paste special'. Uncheck 'Paste all', then uncheck
'Formulas'.
7) Click 'ok'.
tc
Jörgen Waldemark wrote:
I got a question about openoffice 2.10
If i want to add a zero in the beginning of a cell that already have
information. How do i do that??
I got 2600cells with phone numbers and all i need to add 0 in front of
all
the numbers.
It would be great if you learn me how i could do that, Then i save like
4hours work for the company. :)
---------------------------------------------------------------------
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]
