| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to stop time format changing when I merge cell contents?
I am trying to merge to time cells, (both set to English (United States),
Time Type 13:30) both cells display correctly where I entered them (9:00 and 9:45) but when I merge the cell contents using the function =A4&" - "&B4 I get the result 0.375 - 0.406 instead of 9:00 - 9:45 as expected. The destination cell has the same time settings as the two original cells. How do I stop the times converting to decimals and get them to display the way I want them too? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing contents of cell based on Cell Format | Excel Worksheet Functions | |||
| STOP auto format of cell contents | Excel Discussion (Misc queries) | |||
| How do I stop excel from changing my ratios into time format? | Excel Discussion (Misc queries) | |||
| Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
| Excel format changes as I merge into Word document How can I stop | Excel Discussion (Misc queries) | |||
Threaded Mode
