excel annoyance

Out of context: Reply #4

  • Started
  • Last post
  • 10 Responses
  • ********
    0

    Uh ... here's what you do.

    In the column next to it, write this: A1*100

    Where A1 equals the first column/row you want to multiply by 100.

    You can copy that function down the line. Afterwards, copy the entire second column and then Paste Special with just the values in a new column ... delete the other two?

    Also ... formatting the first column so it is not a percent may help as well.

    ...

    THINK MAN THINK!

    ********
    0Permalink
    UpvoteDownvote
    Flag
    Show [[ numHiddenNotes ]] more notesAdd Note
    SaveCancel

View thread