View Single Post
  #2   Report Post  
Gordon
 
Posts: n/a
Default

Bill M. wrote:
I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?


Type in the number 10 in a spare cell. highlight it, select "copy" then
select the column you wish to change, right-click on it, select "paste
Special" and under "Operation" choose divide.

HTH


--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!