entering a # each row adds 1 to the previous cell. Turn off?

When entering numbers in my spreadsheets each row adds another number. i.e.,
2004 becomes 2005, then 2006. A telephone # becomes 811-6001, 6002, 6003.
How do I turn that off so when I pull the corner down to copy it stays the
same?

You can right click and pull the corner and when you release the mouse
you'll get an option of copy cells or hold down ctrl and pull down with left
mouse

--
Regards,

Peo Sjoblom

(No private emails please)


"dbog" <[email protected]> wrote in message
news:[email protected]...
> When entering numbers in my spreadsheets each row adds another number.
> i.e.,
> 2004 becomes 2005, then 2006. A telephone # becomes 811-6001, 6002, 6003.
> How do I turn that off so when I pull the corner down to copy it stays the
> same?