Results 1 to 4 of 4

convert P/L worksheet from USD to CND

This is a discussion on convert P/L worksheet from USD to CND within the Excel Questions forums, part of the Question Forums category; Looking for a short cut to convert worksheet from US currency to Canadian currency and back....

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    1

    Default

    Looking for a short cut to convert worksheet from US currency to Canadian currency and back.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,166

    Default

    Ok seems ok could do UDF if needed

    Sorry im UK as you might guess

    US ?? Canada ?? USD $$$$ or an i wrong, sorry buddy if so whats the difference Jacques Vilernerve in french canada and US the same just canada $$ and US $$$, or is it like EURO and GBP a little different

    What you after buddy

    Jack

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259

    Default

    Here's a piece of code that I just wrote quickly.
    It will prompt you for a conversion number and then multiply all values in the active sheet by that amount . This would allow you to convert from any type of monitary system to another.

    Public Sub ConvertAmonts()
    ConvNum = InputBox("Type in Conversion Number", "Conversion Number")
    For Each c In ActiveSheet.Cells.SpecialCells(xlCellTypeConstants, xlNumbers)
    c.Value = c.Value * ConvNum
    Next
    End Sub
    _________________
    NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
    Adieu,Nimrod
    [ This Message was edited by: Nimrod on 2003-01-05 18:32 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,166

    Default

    Nimrod buddy

    Check your PM! Perfection

    Jack

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com