How do I change a text fraction. eg 1 1/2 into a decimal number, 1.5, using excel 2000
A antac Feb 28, 2005 #1 How do I change a text fraction. eg 1 1/2 into a decimal number, 1.5, using excel 2000
P Peo Sjoblom Feb 28, 2005 #2 Copy an empty cell, select the fraction and do edit>paste special and select add If it is a number fraction like # ?/? just change the format ot a number or general
Copy an empty cell, select the fraction and do edit>paste special and select add If it is a number fraction like # ?/? just change the format ot a number or general
