| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 79576 | 2007-05-25 00:21:00 | Excel question | yorkshirekid (9033) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 552839 | 2007-05-25 21:40:00 | Again - brilliant. I followed all of that whilst listening to Sound of the 70's on BBC Radio 2. You must be a teacher (or should be) as your explanation was spot on; I could actually understand it. Thank you. Give that man a DB (or whatever you like as I hate the stuff) :) | yorkshirekid (9033) | ||
| 552840 | 2007-05-26 00:50:00 | And is come on some Excel whizz out there who show us a much smaller formula that does the same thing..... Try this: =INT(A1)&"' "&INT(12*MOD(A1,1))&"""" You can replace the concatenate statement with the ampersand symbol. Andrew |
andrew93 (249) | ||
| 552841 | 2007-05-26 01:07:00 | :) That's excellent. I've learnt a lot both from the longer formula and this latter shorter one. Time to play with this new found knowledge. Thanks |
yorkshirekid (9033) | ||
| 1 2 | |||||