excel

[harper1]

okay got a massive grid of numbers, say 300 x 300 cells
and all the amounts are in dollars
how would i go about converting them all to pounds, i have the exchange rate on another worksheet.

whats the best wayy??

please help!!!

 

[CupDude]

Make a new worksheet, reference the cells to the original worksheet : first cell e.g. A1 = OriginalWorksheet!A1*ExRate!A$1$ & copy for all cells?

 

[harper1]

thats what i thought of, just thought there may be a fancy way. vlookup etc?

 

[MarkCup]

If you've got pound values you want to convert to say USD, then copy the cell containing the dollar rate, then highlight the entire range of values you want to change.

Edit, Paste Special, Values, Multiply. It will overwrite all cells with the recalculated USD figures.

 

[The Boosh!]

If you've got pound values you want to convert to say USD, then copy the cell containing the dollar rate, then highlight the entire range of values you want to change.

Edit, Paste Special, Values, Multiply. It will overwrite all cells with the recalculated USD figures.

My god youu know your stuff...

Do you do it for a living mark?

Mind if i PM you any other problems i have in the future?

 

[MarkCup]

10 years of building financial models within Excel...so I've uncovered most of its little hidden secrets and shortcuts.

I've always joked that if asked what I do for a living I should just reply "Spreadsheets"...

Keep the problems coming...I love a challenge LOL

 

[The Boosh!]

Roffle. Thanks !!

 

[harper1]

Thanks very much, thats a big help