How do you enter person's height in cell?
 

In a worksheet, I'm trying to enter a person's height as 5-10 for 5 feet, 10
inches but Excel converts it to a whole number. Any suggestions

Precede the entry with an apostrophe or use the scientific metric <g

Regards,

Peo Sjoblom


"Jim" wrote:

In a worksheet, I'm trying to enter a person's height as 5-10 for 5 feet, 10
inches but Excel converts it to a whole number. Any suggestions