How can I change dollar sybbol to euro symbol?

If data is numeric then use Format Cells and choose a format with a Euro
symbol, or if text just do an Edit / Replace.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"zwerver" <zwerver@discussions.microsoft.com> wrote in message
news:1821DD41-E29A-4034-9A2E-9DCB5AB6B4BD@microsoft.com...
>

Hi Ken,

thanks for the info. It was not what I needed. I finally figured out the
various way to use the Euro symbol Including these ways to type it in:
FN > alt > 0128

Control > alt > e

Insert > symbol type 20AC as the character code
Also
Select the cells that you want to format as euro currency style.
Click Euro on the Formatting toolbar (toolbar: A bar with buttons and
options that you use to carry out commands. To display a toolbar, click
Customize on the Tools menu, and then click the Toolbars tab.). If Euro is
not available, you must load the Euro Currency Tools add-in (add-in: A
supplemental program that adds custom commands or custom features to
Microsoft Office.) program.

"Ken Wright" wrote:

> If data is numeric then use Format Cells and choose a format with a Euro
> symbol, or if text just do an Edit / Replace.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "zwerver" <zwerver@discussions.microsoft.com> wrote in message
> news:1821DD41-E29A-4034-9A2E-9DCB5AB6B4BD@microsoft.com...
> >
>
>
>

Ok, glad you are sorted but not sure how that counts as changing a dollar
symbol?

What you have described is what I suggested, ie formatting the data, though
granted if you werent aware of how to actually enter the Euro symbol in the
formatting dialog box, then it didn't really help :-)

Regards
Ken................................


"zwerver" <zwerver@discussions.microsoft.com> wrote in message
news:47A907D6-20EB-429E-9DE4-31F0FC7945C2@microsoft.com...
> Hi Ken,
>
> thanks for the info. It was not what I needed. I finally figured out the
> various way to use the Euro symbol Including these ways to type it in:
> FN > alt > 0128
>
> Control > alt > e
>
> Insert > symbol type 20AC as the character code
> Also
> Select the cells that you want to format as euro currency style.
> Click Euro on the Formatting toolbar (toolbar: A bar with buttons and
> options that you use to carry out commands. To display a toolbar, click
> Customize on the Tools menu, and then click the Toolbars tab.). If Euro
> is
> not available, you must load the Euro Currency Tools add-in (add-in: A
> supplemental program that adds custom commands or custom features to
> Microsoft Office.) program.
>
> "Ken Wright" wrote:
>
>> If data is numeric then use Format Cells and choose a format with a Euro
>> symbol, or if text just do an Edit / Replace.
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>> "zwerver" <zwerver@discussions.microsoft.com> wrote in message
>> news:1821DD41-E29A-4034-9A2E-9DCB5AB6B4BD@microsoft.com...
>> >
>>
>>
>>