| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells for text and numbers
I need to create a cell that will read as a number but display text as well,
but Excel only allows you to customize a cell with one type of text. I am trying to create a time card where the entry could be 8P or 8H or 8F or even 2P. I then want to add up the columns showing the total P's, H's, and F's separately. Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting numbers as text | Excel Discussion (Misc queries) | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| formatting cells with numbers as text | Excel Discussion (Misc queries) | |||
| Formatting from text to numbers | Excel Worksheet Functions | |||
| numbers to text with formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
