View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jjk98 jjk98 is offline
external usenet poster
 
Posts: 14
Default Cell formated as text changes when copied

Oops!

I typed the description incorrectly - the first line of text is "Usages in
1900 - 1900"

Also if the year is not the last thing on the line then it works fine. So if
I type the first line as "Usages in 1900 - 1900 summarized" then the second
year does not change.
--
Thanks for your help - jjk98


"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?
--
Thanks for your help - jjk98