I created a file a few days ago using excel 2003 and had formatted
some cells for percentage. When I typed .5 the cell would display
0.5%. I emailed the file to myself to edit on another computer also
using excel 2003 and today when I type .5 the cell now shows 50%.
When I try to format cell for percentage it indicates that the typed
value will be multiplied by 100 and the result displayed with %
symbol. How do I format a cell using 2003 or 2007 so that when I
type .5 the cell show 0.5% or when 2.5 is typed the cell shows 2.5%
and not 250%?

Thank you.

Jim