excel help needed please

[R&J]

when entering a phone number in to a column and dragging downwards to fill in more cells;
how do I keep the first digit i.e. the 0 from disappearing?

and

how do I stop the number increasing as I drag it down?

It's really getting to me now as I've been trying to sort this for to long now.

Cheers

[Shadytree]

Copy and paste rather than drag and drop

[stone]

Also to prevent the 0 disappearing you can format the cell as text.

[R&J]

Shadytree said:

Copy and paste rather than drag and drop

yeah I would do that but i need to copy about 120 nunmers into about 600 cells each
so dragging will be so much quicker (if i knew how:-) )

[oggs]

[quote=R&J] copy about 120 nunmers into about 600 cells each
[/quote]

[flossythepig]

[quote=R&J]

Shadytree said:

Copy and paste rather than drag and drop

yeah I would do that but i need to copy about 120 nunmers into about 600 cells each
so dragging will be so much quicker (if i knew how:-) )[/quote]
Ctrl-C the cell to copy (it will have a dotted line around it.
Left mouse button down in first destination cell then drag as far down as you like then release mouse button.
Ctrl-V to paste in all the cells.

[Big_Dan]

Put an apostrophe in as the first character before the number

[R&J]

Is there an OGGS lurking on every forum?

[R&J]

flossythepig said:

Ctrl-C the cell to copy (it will have a dotted line around it.
Left mouse button down in first destination cell then drag as far down as you like then release mouse button.
Ctrl-V to paste in all the cells.

I works ..............Cheers

[toni896]

what version of excel?

In 2003, I need to press cntr to add a series ? just dragging copies.

[R&J]

toni896 said:

what version of excel?

In 2003, I need to press cntr to add a series ? just dragging copies.

I'm using 2003

[Jinx]

You can also use Ctrl + D for "fill down"