Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Data Entry
Is there a way to format data so that when entering someone's height as 511
it will come up as 5'11" and when entering 63 it would come up as 6'3" ? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Data Entry
There may be a way, but I wouldn't do this.
Instead, use two cells (feet and inches). Or use one cell and enter total inches. It'll make any further arithmetic much, much easier. Ayuda wrote: Is there a way to format data so that when entering someone's height as 511 it will come up as 5'11" and when entering 63 it would come up as 6'3" ? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock format but allow data entry | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |