<div>
CHAR(128) &nbsp;is just a character, not a number format. &nbsp;Number formats are in the Format Cells dialog box. &nbsp;Here's the Microsoft page on the subject: <a href="http://msdn.microsoft.com/en-us/library/office/aa224873%28v=office.11%29.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/office/aa224873%28v=office.11%29.aspx</a>
</div>


CHAR(128)  is just a character, not a number format.  Number formats are in the Format Cells dialog box.  Here's the Microsoft page on the subject: http://msdn.microsoft.com/en-us/library/office/aa224873%28v=office.11%29.aspx [http://msdn.microsoft.com/en-us/library/office/aa224873%28v=office.11%29.aspx]

<div>
Thanks, I've been to that site, however, it did not give me a way to show that the value is in Euro's and not dollars. Therefore, what's the number format for a Euro? Could I just copy the Euro symbol and replace $##,### with €##,### ?
</div>


Thanks, I've been to that site, however, it did not give me a way to show that the value is in Euro's and not dollars. Therefore, what's the number format for a Euro? Could I just copy the Euro symbol and replace $##,### with €##,### ?

<div>
thanks to everyone and Merry Christmas
</div>


<div>
Note: I copied a Euro symbol and embedded in my number format seemed to be the easiest thing to do for me.
</div>


Note: I copied a Euro symbol and embedded in my number format seemed to be the easiest thing to do for me.

<div>
<div class="content wysiwyg-content">
Folks,<br />
I have a VBA need to format a cell as EURO and I can't get there: <br />
ActiveSheet.Range(&quot;C4:C8&quot;)<wbr />.Select<br />
Selection.NumberFormat = CHAR(128)
</div>
</div>


Folks,
I have a VBA need to format a cell as EURO and I can't get there: 
ActiveSheet.Range("C4:C8").Select
Selection.NumberFormat = CHAR(128)

Set number format to euro using vba

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.