View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default convert number into a decimal

Hello I have a spreadsheet in column b there is a number when I try
to format the number to a percentange I get the wrong answer. example
column B has a 5 the answer should be 5% . but when I format the cell for
decimal I get 500.00% how do I correct this thanks column is formatted
as general