RE: Currency changer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi tarynnl,

Perhaps I'm missing something, one can but you don't *need* to write VBA
code to achieve this.

Unless there's some valid reason that you (or your users) would want to
prevent it, why not just use the native, out-of the box functionality of
Excel as follows...

1. Select the cell (or cells) required.
2. Right mouse click will bring up a short-cut menu. Choose "Format Cells..."
(Selecting "Cells" from the "Format" menu of Excel's main menu bar or Ctrl+1
will do the same thing).
3. On the "Number" tab of the dialog box that appears, choose either
"Currency" or "Accounting" from the Category list.
4. Enter the number of decimal places that you'd like to display and then
choose the desired currency symbol from the Symbol drop-down list.
5. Click OK and note that your cell(s) are now formatted with the desired
currency symbol.

That changes the *format* and display of the underlying numbers in the cell
(but not the numbers themselves). If you're actually trying to convert the
original numbers from your local currency into some other currency (say
EUR->GBP for example), then that is a completely separate question.

HTH, Sean

"tarynnl" wrote:

>
> I need to a button to add onto a spreadsheet , so that when it is
> pressed a option box appears prompting user to type in a currency
> format (or select a currency format) and it will automatically change
> the currency format of the numbers on the spreadsheet.
> I think a macro/VB script will do this but dont know how to write one
>
>
> --
> tarynnl
> ------------------------------------------------------------------------
> tarynnl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1527
> View this thread: http://www.excelforum.com/showthread.php?threadid=385559
>
>
.

Relevant Pages

  • Re: Finetune formula to get currency format?
    ... Then format the cell as Currency. ... goes into the totals column but there is no total known so the result ...
    (microsoft.public.excel)
  • Re: Multiply currency
    ... Format shows that the cell is prepared to accept a value as currency, not that it actually contains a currency value. ... For instance, if you were to type "Fred" into the cell, there is no way that Excel could intrerpret that as currency, but the format would not change. ... You should understand there is an essential difference between a number displayed as currency and a text string containing letters or symbols and numeric characters. ...
    (microsoft.public.excel.misc)
  • Re: Add totals at end of the report with unknow number of rows wit
    ... How about changing the format for the count cell, try this, tested with 2002 ... currency before the macro gets new data ... Dim rng As Range ...
    (microsoft.public.excel.newusers)
  • Use a checkbox to set cell format
    ... Normal format of the particular cell would be Currency with 2 ... I also need a "checkbox" to say weather this is ...
    (microsoft.public.excel.programming)
  • Re: Currency format
    ... If you try the Function "Fixed" under the Text formula selection it will ... unless the regional settings recognize the currency symbol. ... And, of course, to format *that* totaling cell, for example: ...
    (microsoft.public.excel.worksheet.functions)