View original (French)

Excel 2003 : (e) becomes € in my cells

Solved
midiweb -  
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   -
Hello,
in Excel 2003, when I put (e) to mark the feminine form of a past participle, it changes to €.

For example,

Créé(e) becomes Créé€

How can I prevent this?

5 answers

Answer 1 / 5
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
 
Hello,

go to 'tools / options... / spelling / autocorrect options...'
Uncheck ' autocorrect while typing' or delete the line (e) €

eric

--
You will never respond to an unsolicited message...
Well, that's done.
9
Adrelina
 
Excellent !!! Thank you Eric!
0
Jeanmi
 
Very effective; thank you Eric.
0
Marilou
 

But what toolbox?

I can't find any "tools" tab in the top panel of an Excel sheet!

Thank you for your response

0
cousinhub29 Posted messages 1112 Registration date   Status Member Last intervention   383 > Marilou
 

Hello, (Also!)

This answer was regarding Excel 2003, with its menus..

In the new versions:

- File/Options (at the bottom)/Proofing/AutoCorrect Options

Have a good day

1
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476 > Antoine
 

Very personal opinion, and it only engages its author!

0
Answer 2 / 5
Anonymous user
 
Your cell is certainly in "currency" format.
1
Answer 3 / 5
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285
 

Hello everyone,

A brief explanation for the transformation of (e) into €: in the early days of the euro, many keyboards did not have the "€" character. Users would therefore enter "(e)" instead, which Excel or Word would then convert into "€".

Daniel
1
Answer 4 / 5
midiweb
 
Hi, the cells are in standard format. When I choose "text", some cells show #### characters.
0
Answer 5 / 5
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
This sheet is tailor-made for you: https://forums.commentcamarche.net/forum/affich-37641870-word-correction-automatique-intempestive-annuler

--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
0