Pocket Excel Percent Format

brox · 01-09-04, 09:40 PM

Hi All,
Can anyone confirm that the percent format in pocket excel is faulty. I'm running Windows Mobile 2003.
If i have a number in a cell (say 57) then change the NUMBER format of the cell to PERCENTAGE. It gives me 5700.00%. Changing the decimal point position add the decimal places correctly, but I still get a value 1000 times larger that I expect.

Michael_j · 01-09-04, 10:22 PM

Since it is set up as a % you need to type the number in as .57

brox · 01-09-04, 10:59 PM

Makes sense really. Thanks.