/-/S'pht-Translator-Active/-/


Re: newbee spreadsheet question (OT)
Posted By: ReiginkoDate: 5/24/05 3:50 a.m.

In Response To: Re: newbee spreadsheet question (OT) (Yossarian)

: Well, all I can attest to is Excel. Next to each cell, do the formula =A1*.25
: where A1 is the cell with the value to be multiplied. If all your values
: are in one column, simply copy the formula and paste down to the bottom of
: your list. Now you have to convert the formulas to values. Highlight all
: of your formula cells, right-click and "Copy", right-click again
: and "Paste Special". Click the "Values" checkbox and
: then OK. The formulas are changed to numbers. Cut these and paste them
: over the original values and that's it.

: If you can't get it right, send it to me in CSV format and I'll see if I can
: do it...

: -Y

That works exactly the same way in Appleworks as well.

- Reiginko

[ Post a Reply | Message Index | Read Prev Msg | Read Next Msg ]
Pre-2004 Posts

Replies:

newbee spreadsheet question (OT)•M 5/23/05 2:16 p.m.
     Re: newbee spreadsheet question (OT)Yossarian 5/23/05 4:17 p.m.
           Re: newbee spreadsheet question (OT)Reiginko 5/24/05 3:50 a.m.
           Re: newbee spreadsheet question (solved)•M 5/24/05 3:55 a.m.
                 Re: newbee spreadsheet question (solved)Yossarian 5/24/05 4:08 a.m.

[ Post a Reply | Message Index | Read Prev Msg | Read Next Msg ]
Pre-2004 Posts

 

 

Your Name:
Your E-Mail Address:
Subject:
Message:

If you'd like to include a link to another page with your message,
please provide both the URL address and the title of the page:

Optional Link URL:
Optional Link Title:

If necessary, enter your password below:

Password:
 

 

Problems? Suggestions? Comments? Email maintainer@bungie.org

Marathon's Story Forum is maintained with WebBBS 5.12.