Cell formated as text changes when copied
That is Excel being helpful and autofilling for you.
Although row 2 should read Usages in 1900 - 1906
i.e. only the 1905 will increment.
Right-click on the fill handle(little square) and drag down.
Release and "Copy Cells"
Gord Dibben MS Excel MVP
On Mon, 21 May 2007 16:03:02 -0700, jjk98
wrote:
Spreadsheet with 10 rows (all formated as text) and 1 column. I enter the
string: Usages in 1900 - 1905 in the top row. I select the top row and catch
the sqaure at the lower right corner and "copy" the text to the next 9 rows.
The text in the second line is now "Usages in 1900 - 1901"
in the third row it is "Usages in 1900 - 1902"
and so on.
Why is the text changing?
|