accidentally entered #'s as %s

  • Thread starter Thread starter koki
  • Start date Start date
K

koki

i have a hugh spread sheet. the numbers were accidentally
entered as percentages. how can i get rid of the
percentage formatting w/o the decimal point changing position.

ie. i want -0.251% to read -.251. when i undo the
percentage formatting it ='s -0.002514568.

sorry:( i know it's a basic question, but i can figure
this out for the life of me.

thanks
 
put 100 in a cell somewhere, and copy this cell, select the region o
your values, and paste special, multiply, and reformat to numbe
 
Back
Top