| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two formats in one cell
I have two values in one cell concatenated using &"/"&. The first part I
want to show two values 12/13. The second part I want to display 925 (=12/13). Is there a way to format one cell to show 12/13/92%? Se formula below. Thanks!! ='Resource Info'!E29&"/"&'Resource Info'!D29&"/"&'Resource Info'!E29/'Resource Info'!D29 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Can't open doc. Too many different cell formats. | Excel Discussion (Misc queries) | |||
| How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
Threaded Mode
