OVH Cloud OVH Cloud

excel

2 réponses
Avatar
BIBBYBIBBER
When I enter a number in a newly opened fresh spreadsheet the number is
automatically divided by 10.0. When I enter a number below 1.0 this
effect does not occur.

I have used Excel for over 8 years and never have experienced this
phenomenon, it is driving me crazy.

Can someone please tell me what is going on and how to fix it?

...Alan

2 réponses

Avatar
Jacquouille
Bonjour, svp et merci
sont des mots qui ouvrent le coeur et la plume des gens du MPFE
Je ne parle pas le Grand Breton,, mais je n'ai rien vu de tel dans ton msg.
Pour ton problème, vas voir du côté de ta virgule flottante.
Au revoir et bonne chance.
--
Bien amicalmement,
Vivement conseillés:
http://www.excelabo.net
http://jacxl.free.fr/mpfe/trombino.html
http://dj.joss.free.fr/netiquet.htm
http://frederic.sigonneau.free.fr/

Jacquouille.

"BIBBYBIBBER" a écrit dans le message de news:

When I enter a number in a newly opened fresh spreadsheet the number is
automatically divided by 10.0. When I enter a number below 1.0 this
effect does not occur.

I have used Excel for over 8 years and never have experienced this
phenomenon, it is driving me crazy.

Can someone please tell me what is going on and how to fix it?

...Alan



Avatar
Clément Marcotte
Outils - Options - Modifications - Décimale fixe.

Just use a dictionary to translate. Don't have time to find an English Excel
to translate myself.




"BIBBYBIBBER" a écrit dans le message de news:

When I enter a number in a newly opened fresh spreadsheet the number is
automatically divided by 10.0. When I enter a number below 1.0 this
effect does not occur.

I have used Excel for over 8 years and never have experienced this
phenomenon, it is driving me crazy.

Can someone please tell me what is going on and how to fix it?

...Alan