| 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. |
| 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 | |||
Threaded Mode
