Search results

Hi, You could just use this and custom format to mmm-yy =DATEVALUE(A1)

Hi James, I've just tried your method and it works if your cursor is in the formula bar, but if you put the RANDBETWEEN() in B2 first, then select your range B2:K200 and then hit the auto-sum you get a random number in each corner of the range that are identical. Just thought I'd share...

Not to late am I? - Well done again @SirJB7

Just tell us what it is, or upload a file or provide a link to what it is ....... thanks Or just keep us guessing :DD:DD

Sorry @Faseeh This one passed me by, but hope I'm not to late to congratulate you on passing your 2,000th posting. :oops: Well done!

You might find this one useful perhaps? http://chandoo.org/wp/2011/01/11/embed-youtube-videos-excel/

@Smallman I agree with you about Tom Ogilvy he helped me a few times when I first started out back in the last century :) Glad to hear he's still helping out.

Well done Narayan congratulations on reaching your 7,000th post. :cool::cool::cool:

:):):):):):)

Looks like our friend here may be able to help? http://www.freelancer.co.uk/u/NARAYANK991.html @NARAYANK991

Congratulations @Somendra Misra and @Sajan very well deserved for both of you :cool::cool:

Sorry @Luke M, I clicked the wrong one :eek:

Congratulations @Somendra Misra on reaching your 1,000th post, you are truly a "Well-Known Member", keep up the good work. ;)

@SirJB7 With a young baby and those sleepless nights he probably feels about 60 :DD:DD:DD

Hi @Luke M Forget how old you are, it's a case of how old you feel that counts :DD:DD:DD

Hi Hui..., Congratulations on reaching your 6,000th post. Thank you for all the work you put in here, please may it continue.

Hi Swissshield, Welcome to the forum, try this, insert a couple of columns so your data is in now in columns C1 to CX (that should be 100 columns wide), then in A1 put this and drag downwards =OFFSET($C$1,INT((ROW()-1)/100),MOD(ROW()-1,100)) Sorry misread your question - you wanted it column...

Hi, Here's a couple of free downloads, I haven't used them myself but I'm still using Microsoft Money 2001 which I've been using for years, so sometime in the near future I'll need to find something more up to date myself ;)...

If the numbers you want to hide are the results of formulas, then you could use something like this to hide zero's, minus numbers and errors =IFERROR(IF(A1<=0,"",A1),"")

@reddwarf4ever Here are some more custom formats here you may find useful http://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/

Hi @Somendra Misra Thanks for the explanation, I've read through it a few times now and the grey matter is slowly beginning to work. I've kept a copy of the spreadsheet for future reference because if this question comes up in the future I'll need it! :DD:DD:DD

@SirJB7 I knew I was barking up the wrong tree with my second attempt :eek: @NARAYANK991 @Sajan That's brilliant, but could one of you experts explain how that works, only I haven't a clue. :confused:

Now Mohan, you've just made it harder! I'm struggling with that one. I can list the first part of the number 0.60x1.00 by modifying the last formula and creating an array formula =SMALL(IFERROR(LEFT($A$1:$L$23,FIND("x",$A$1:$L$23)-1)+0,""),ROW(1:1)) Ctrl+Shift+Enter But the problem is then...

Try this =SMALL($A$1:$L$23,ROW(1:1)) copy down

Duplicate post and answered here http://chandoo.org/forum/threads/filling-formulas-in-a-column.15205/