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]
