How do you enter person's height in cell?

J

Jim

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
 
P

Peo Sjoblom

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

Regards,

Peo Sjoblom
 
Top