Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: format of columns change

    Setup: W2000 & Excel2000

    Can anyone explain to me what is happening in the following scenario:

    I set the format for several cells to "General" (all in row G). I then input a number in the field. (I don't use number as the format because of the appearance). It seems that when I copy/paste that (and several of the lines around it) down the page the format is changed to a "Time" sometimes. The columns immediately to the left (Row F) contain are formatted for "Time" and are calculating a value based on other rows. After copying I do a clear contents. I can check the format and it will say "General", but then at some point input a value and the format has become Time.

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Try PASTE SPECIAL > Values and see if that helps.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    The problem is that it usually changes (or I think it changes) after I have been entering data (i.e. some days later).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •