Question Locked

How do I keep the format of a number when concatenated with a text cell.

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The spreadsheet was created in Excel 2003, I'm modifying it using Excel 2007 but it will go back to users with only 2003

This is how cell E10 displays
2:38
this is what is really in the cell
0.109722222222222 The cell format is Custom h:mm
I need to concatenate it with the text in A10 "All Other" so it looks like
"All Other (2:38)" because the number changes and there is too much room for error if the user needs to type the number next to the text for each new report.
The concatenated cell displays
"All Other (0.109722222222222)"
How do I keep the format of the number as 2:38 when joined with the text?

3 replies

by tobif

="All other (" &TEXT(E10,"h:mm") & ")"

by dcdfntech

Thank you so much! Its beautiful.The labels on my Excel graphs now supply all the needed information and they look really great. I really appreciate your help.

This discussion is closed to new replies.