Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
redback9454
 
Posts: n/a
Default how do i change euros into australian dollars

hi,

i have a whole pricelist that needs to be converted from euros into
australian dollars,
the formula would be: <the number*1.63 how do i quikly convert this??
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

i have a whole pricelist that needs to be converted from euros into
australian dollars,
the formula would be: <the number*1.63 how do i quikly convert this??


Enter 1.63 in a free cell & copy it.

Select the range of cells to be converted & Edit -- Paste Special --
Multiply -- OK.

Rgds,
Andy


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i input euros and have it convert into dollars in the same. n1ghthawk Excel Discussion (Misc queries) 1 January 21st 05 04:16 PM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 01:57 AM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Worksheet Row Change event crazybass2 Excel Discussion (Misc queries) 4 December 8th 04 05:29 PM


All times are GMT +1. The time now is 12:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"