Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
christian hertzug
 
Posts: n/a
Default new romanian currency (ron)

how can i change the old currency (lei) in to the new one (ron)?
all the best for all!

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default new romanian currency (ron)

See:

http://www.xe.com/

use the "more currencies required" option.

--
Gary's Student


"christian hertzug" wrote:

how can i change the old currency (lei) in to the new one (ron)?
all the best for all!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default new romanian currency (ron)

As I understand it, 1 RON=10,000 ROL so you need to divide by 10,000

Put 10,000 in a spare cell and copy.
Select currency data to be converted
Edit==Paste Special==Operation-Divide
Delete the 10,000 in the spare cell

HTH

"christian hertzug" wrote:

how can i change the old currency (lei) in to the new one (ron)?
all the best for all!

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
Dollar sign alignment - Accounting vs Currency style MikeC Excel Discussion (Misc queries) 3 March 23rd 06 06:18 PM
Comma separator for custom Currency Bald Eagle Excel Discussion (Misc queries) 0 January 16th 06 11:16 PM
Comma separator for custom Currency (Indian Rupee) Bald Eagle Excel Discussion (Misc queries) 1 January 15th 06 06:45 PM
Incorrect Currency Displayed Maxy Excel Discussion (Misc queries) 4 November 9th 05 03:20 PM
Currency Style button Anita Excel Discussion (Misc queries) 3 April 18th 05 12:48 AM


All times are GMT +1. The time now is 10:27 PM.

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"