Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
zwerver
 
Posts: n/a
Default How can I change dollar sybbol to euro symbol?


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ken Wright
 
Posts: n/a
Default 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" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.newusers
zwerver
 
Posts: n/a
Default How can I change dollar sybbol to euro symbol?

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" wrote in message
...




  #4   Report Post  
Posted to microsoft.public.excel.newusers
Ken Wright
 
Posts: n/a
Default How can I change dollar sybbol to euro symbol?

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" wrote in message
...
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" wrote in message
...






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
Find function alamo Excel Worksheet Functions 1 September 16th 05 02:01 PM
How do i change the currency from dollar to GB pounds Imraan Rawat New Users to Excel 2 July 29th 05 03:37 AM
i want to change dollar sign to rands on excel invoice? sylvia Excel Discussion (Misc queries) 4 July 19th 05 11:14 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Change Currency symbol dependant upon selected cell value Fred Excel Discussion (Misc queries) 3 March 23rd 05 12:57 PM


All times are GMT +1. The time now is 07:41 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"