the file may have been opened but not edited on a machine using 2007
before being emailed if that would make any difference

Jim

On Aug 30, 11:28 am, wrote:
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