Excel 2007 : percentage

[Dazzle42]

Hi, Im having trouble in my spreadsheet,
every column is stuck in the percentage mode.
when I insert a number it comes up as a percent/decimal of 100.

eg, type in 1, the cell lists 0.01

how do I remove this.

help/ thank you.

[vlady]

select all the cells then right-click mouse ->choose format cell - > number tab -> select number

[Dazzle42]

thanks vlady,
ive tried that, it does remove the % symbol, but still displays numbers as 0.01

ie. when i type in '1' it shows up as '0.01'

I want it to show up as the whole number I type in,
eg. type in '1' shows as '1' or '2' as '2'
currently 1 shows as 0.01, 2 as 0.02 etc
and if i change the number to no decimal places. 1 shows as 0, & 2 shows as 0

[vlady]

you should format the cells first to number or general before data entry.

if there's an entry like 0.01 then change to number without decimal it will surely give 0 co'z thats the whole number for 0.01

[Dazzle42]

that has no effect,
formatting the cells prior to data entry, does not change the outcome for general, number or even date, I want to remove the percentage effect so that whole numbers display from what I type

[vlady]

i think there's a hidden prog in that workbook. can you upload a copy ( dummy )of that workbook i'll try to find it somehow. thanks

[Dazzle42]

ok thanks.

here tis

[vlady]

no problem in my unit.i can change it.
try it again if it does'nt work with you,, try going to tools-> option-> edit-> uncheck the percentage & separators there.

if doesn't work. have no idea anymore.
HTH

[Dazzle42]

OK thanks for that