Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

€ Euro Symbol €

Status
Not open for further replies.
pwilliams

pwilliams

MIS
Nov 20, 2000
15
GB
Excel and Word 97 both display the Euro symbol on the screen, and in print preview but only Word seems to be able to print the Euro symbol.

Which normally wouldn't be a problem but the company reports in euros!

has anyone any ideas?

thanks,
Pete
 
Sort by date Sort by votes
Are you saying you can't print the Euro symbol from Excel? What DOES print, if not the euro? Tell us everything you can, including how you get the euro symbol into Excel in the first place: are you using cell formatting or inserting the symbol or what?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Yes - I can't print the euro symbol from excel. But it is fine from word.

I have changed the currency in control panel to Euro symbol and formatted the cells in question as currency.

cheers,
pete
 
Upvote 0 Downvote
Pete: I can't help you if you can't answer ALL my questions. I need to know how it was done so I know if you're inserting them properly; and then we can go from there.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
the euro symbols aren't inserted as the cells in question contain array formulae. if i insert a euro symbol it will (i assume) overwrite the formulae which is no good to me.
i have formatted the cells that contain the formula as currency and changed the windows currency symbol to euros using control panel.
 
Upvote 0 Downvote
Aha! And you have changed the symbol from $ to € in the Format-Cells box? What version of Excel, please? I can do this without problem in 2000, but I don't have 97 here (like I do at work) to compare them. I'll check that tomorrow.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Aha! And you have changed the symbol from $ to € in the Format-Cells box? I can do this without problem in 2000, but I don't have 97 here (like I do at work) to compare them. I'll check that tomorrow.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AndrewMozley
  • Locked
  • Question
Remove recently used symbol
Replies
8
Views
313
Deniall
Deniall
jlockley
  • Locked
  • Helpful tip
Excel: Importing European account information (German bank spreadsheets are the worst.). 2
Replies
14
Views
205
strongm
strongm
whughesiii
  • Locked
  • Question
Word 2003 Prints Euro Symbol or blank space instead of checkbox
Replies
1
Views
108
flyboytim
flyboytim
zinderellie
  • Locked
  • Question
Vlookup Using Less Than (<) Symbol in Table Data 1
Replies
3
Views
42
SkipVought
S
bloomlight
  • Locked
  • Question
symbols get lost while converting from word 2007 to word 2010, how to fix?
Replies
2
Views
45
Madawc
Madawc

Part and Inventory Search

Sponsor

Back
Top