|
Moderator
Join Date: Jun 2001
Location: Geyserville, CA
Posts: 6,921
|
It's the order of formatting. If there is a number in the cell, and you press the % autoformat button, it keeps the decimal where it is and simply converts the display format. Hence 2.5 becomes 2.5%
If you format the cell for percentage first, you then need to enter the digits with the decimal in the proper location. So 0.025 properly displays 2.5%
__________________
Don Plumley
M235i
memories: 87 911, 96 993, 13 Cayenne
|