View original (French)

Excel 2003 : (e) becomes € in my cells

Solved
midiweb -  
danielc0 Posted messages 2175 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

  1.
    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
    1. Adrelina
       
      Excellent !!! Thank you Eric!
      0
    2. Jeanmi
       
      Very effective; thank you Eric.
      0
    3. 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
    4. 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
    5. Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   17 480 > Antoine
       

      Very personal opinion, and it only engages its author!

      0
  2. Anonymous user
     
    Your cell is certainly in "currency" format.
    1
  3. danielc0 Posted messages 2175 Registration date   Status Member Last intervention   286
     

    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
  4. midiweb
     
    Hi, the cells are in standard format. When I choose "text", some cells show #### characters.
    0