Search results

@VDS When you are going to use the formula then no need to set the custom format because your result will come directly as you required Exp Say your Date range is in A2:A1000 and you want the Date formula to be in "MMMM,YYYY" in the Range B2:B1000 Then you use the Formula as per mine or...

@VDS That is not a formula, what faseeh explained you select the Range which you want to the Date format as MMMM, YYYY Say your range is $B2:$B1000 select the range mouse right click format cells Custom in Type select the format Desire Thanks

@vds that is not in date format it must be in text format please check the Range B84

@VDS Try this, say your Expiry date column in E and month column in F then try in F2 =TEXT(E2,"MMMM, YYYY") Hope it clear other wise please give some more details Thanks

@Ranjeet Hello, first of all i would like to remind you this is week end and some of our members are from different places so you have to patient to get the replay about your question. please read the forum rules once again if you read already Forum Rules coming to your point please check...

@somnath i didn't get any macro in your attached file

@nacer sala Welcome to Changoo.org, Glad you are here, first of all i would like to inform you that before post a question please read the forum instruction from the given link http://chandoo.org/forum/threads/new-users-please-read.294/ hope you understand Thanks

@Portucale Welcome to Changoo.org, Glad you are here, as per my understanding your First Column that is Column A named as ADV_OffphoneHrs and Column B as ADV_OffPhone if it is correct then correct this line as for i = 0 change for i = 2 it is better to upload a sample file to get...

@lohit Hello Very Good Morning Thanks for your Valuable Replay Sorry for my late replay, i was just out away from my system for 2 days that's why i can't replay you as per your instruction i check there is no Disable Addins list in there. now i am going to do your 2,3,4 steps let see...

@SirJB7 Thanks for your Replay Hmm, i can't upload the file here sir if you will give your mail id then i will send the files to you Thanking You Regards

@Hui Thank you Sir, i will try as per your instruction tomorrow in my office, if any problem i will inform you Thanking You With Regards

Sure Sir, i will send the tom Thanking you With Regards

@Narayan Sir, as per you instruction i un Install the Office and Re Install but there is no change it will crash the excel file Regards

@Mridul Welcome to Chandoo.org, Glad you Are here you can use move or copy option open your both files 1. Select the Invoice!b5 sheet 2. Press the mouse right click button 3. Select Move or copy 4. Select the Option To Book (where you want to move the sheet) 5. Choose where you want...

@Narayan Sir, thanks for your replay as per your instruction now i am going to uninstall the Office 2007 and reinstall let me check what will happen after that Note: now i have a new hard disk Regards Patnaik

@Narayan as per your instruction, i check 2 files in another system from 11:00 clock to 1:00 clock there i didn't get any Excel crash report so what i will do now With Regards Patnaik

no i didn't check that, Give me some couple of time i will check about this problem Patnaik

Sir, i am not notice that is the excel file crash on every file let me check this with open a blank excel file, yes the file is crashed every time when i open the my working files which are complete using in VBA and Formula Patnaik

@Hui Sir after long time i got replay from you, Thanks a lot for your replay as per your instruction i check for addin 1. Click the Excel Option 2. Add in 3. Manage (Excel Add-ins) 4. Go now it's display the Add-ins box without Right Click 1. Analysis Tool Pack 2...

@Narayan Sir, Thanks for your quick reply no i open only my excel workbook only with Tally package and Mozila Firefox that's all

@Shrivallabha Thanks for your quick response and your valuable Msg, you are correct with given link no body will sure that is works perfect @Narayan Sir Thanks for your replay, as per your points 2. The File Crashes while on using after some time when it's going to Calculate and Save...

Hello Friends I have small request why our some excel files are crashed after some times, how can we identify the problem, is there any way to trash out why the file is crashed. When i Google search then i got this http://www.appspro.com/Utilities/CodeCleaner.htm but i didn't check this...

@Vds did you try as per deb solution =SpellNumber(Round(A1,0)) off course i don't have the Excel 2003 but i save a sample file in the format of 97-2003 and i run the code it's working =SpellNumber(ROUND(A1,0)) if any problem please let us with your sample file Thanks

@Samantha Glad your problem solve, welcome back if any problem Thanks

@Praneeth may be this will help, please try the below code in Tab birth-day reminder range("E9") =IF(C9=TODAY(),HYPERLINK("mailto:"&D9&","&G9&"?subject="&C$4&"&body="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5,"$",B9),"@",$C$6),CHAR(10),"%0a"),"send e-mail"),"") say you have another email id...