| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter TODAY if cell has data | New Users to Excel | |||
| cell height changing when using autofill | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Linear Mode
