|
Registered
Join Date: Jan 2002
Location: Nor California & Pac NW
Posts: 24,857
|
Excel question
I'm stumped on this one.
Normally, when I've formatted a cell as percentage, to enter 2.5% I can simply input "2.5" and Excel understands this is 2.5%.
Now, when I've formatted a cell as percentage, to enter 2.5% I have to input "0.025". If I input "2.5" Excel treats it as 250%.
What has changed?
__________________
1989 3.2 Carrera coupe; 1988 Westy Vanagon, Zetec; 1986 E28 M30; 1994 W124; 2004 S211
What? Uh . . . “he” and “him”?
|