| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format parts of cell differently
I am using combining two time cells into one cell along with a separator of "
- ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format Displays Differently Between Users | Excel Discussion (Misc queries) | |||
| Date glitch? First 12 days of month format differently than the r | Excel Discussion (Misc queries) | |||
| How do you format each slice differently in a 3-D pie chart? | Charts and Charting in Excel | |||
| open Excel formatted differently than the default format | Excel Discussion (Misc queries) | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Threaded Mode
