Hi and thanks for looking at my question, which is.
I would like to enter 2 numbers in the same cell i.e;
300-900
and have it format to
3:00-9:00
I can use the following for single number entries
i.e; 300 would format to 3:00
Please Login or Register to view this content.
any help or pointers would be helpful
if 300-900 is already in the cell, then this should work... =LEFT(A2,1)&":"&MID(A2,2,4)&":"&RIGHT(A2,2)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
=concatenate(left(a2,1),":",mid(a2,2,2),"-",mid(a2,5,1),":",right(a2,2))
Hi I would like to format the cell that the actual numbers are in using Format cell option
both your formulas work however not on the original cell
thanks
let me see if I have this straight, you have, in one cell 300-900 and you want that converted in another cell to 3:00-9:00 AND you want either or both to be formatted as numbers, is that right? You can have them individually in cells (say A2 has 300 in it and B2 has 900 in it) as numbers but I don't believe it is possible to have 3:00-9:00 in one cell as a number nor 300-900 as a number. Am I mistaken about what you want?
You are correct that I want eg 300-900 converted to 3:00-9:00
I can format the cell with say 300 converted to 3:00 by using Format Cell "Custom" option and using
I thought that I could have usedPlease Login or Register to view this content.
but not that simplePlease Login or Register to view this content.
Last edited by Toonies; 05-05-2014 at 02:47 PM. Reason: Custom not Special
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks