$$Excel-Macros$$
Hi All, I would like to be taken out from this distro list. Could you please help with this ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ VAT CHECK NUMBER FORMULA
Hi All, I need some help on creating a formula. I am currently checking the VAT num of our customer and would like to have a formula which check the Validity and return a VALID or NOT VALID in a cell.( see excel file ). VAT registration numbers should be tested as follows: 1. The *first seven digits* of the VAT registration number are *listed vertically* 2. Each digit is multiplied by a number, starting with 8 and decreasing to 2. 3. The sum of the multiplications is calculated. 4. *97* is subtracted from the sum as many times as is necessary to arrive at a negative number. 5. The negative number should be the same as the last 2 digits of the VAT registration number if it is valid. *Example* VAT registration number *GB339072747* 3 *8 = 24 3 *7 = 21 9 *6 = 54 0 *5 = 0 7 *4 = 28 2 *3 = 6 7 *2 = 14 Total = 147 147 - 97 = 50 - 97 = - 47 As the negative number(- 47) is the same as the last two digits of the VAT number, the number is valid. I have attached an xls file where u can add the formula. Thanks so much for your help Regards Nourredine BELHAJ +41783081988 +33665248617 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe VAT CHECK.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Formula to retrieve only numbers in a Cell
Thanks Norman, You are the only one who found a solution. Have a good one. Nour 2009/10/22 Norman May nor...@gmail.com Try the attached workbook. It contains a user defined function from www.ozgrid.com Norman On Thu, Oct 22, 2009 at 3:17 AM, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, I need some help. I have a cell where there is Account Number and Cust Name and a codification before the Acct Num. *PlanGroup* P#C1299 J L Morison (India) Ltd I would like a formula that is taking only numbers from this cell. Could you help with this ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Formula to retrieve only numbers in a Cell
Hi All, I need some help. I have a cell where there is Account Number and Cust Name and a codification before the Acct Num. *PlanGroup* P#C1299 J L Morison (India) Ltd I would like a formula that is taking only numbers from this cell. Could you help with this ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Excel_Formula_AcctNum.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: ROUNDUP
Thanks so much 2009/8/25 jsa-dk johannes.saugbj...@mail.tele.dk ROUNDUP(9235200,23*2;-6)/2000 On Aug 25, 1:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: ROUNDUP
Hi Jonell, Thanks much appreciated. it works fine. Regards Nour 2009/8/26 jonell jon...@live.com.au On Aug 25, 9:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 Hi Nourredine, A solution is attached which can use either the RoundUp or RoundDown functions and covers the range from1 to 99.9 million. You can change the formula to use it for numbers less than 1m as demonstrated. Hope this is what you are looking for. Regards, Jonell -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ ROUNDUP
Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Mail Merge Word Excel 2003
Hi there, Thanks so much it works fine now. Have a good one. Nourredine 2009/6/25 Upendra Singh upendrasinghsen...@gmail.com Hi Nourredine, Do as Below : 1. In the word merged document, right click the merged field for which you want to change the format. 2. Click “Toggle Field Code” 3. You will see something like { MERGEFIELD Dollar_Value} where “Dollar_Value” is the merge Field. 4. Append \# #,##0.00. 5. Right Click and Click Update field and You’ve done. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don’t. - *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *NOURREDINE BELHAJ *Sent:* Thursday, June 25, 2009 6:49 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Mail Merge Word Excel 2003 Hi All, Hope you are all fine. I have an issue with the Word Function Mail Merge. I have an xls with columns Adress Cust Name Invoice Amount Date. When I m doing the Mail Merge the Number Format is as below ; 6027642.719997 I want to change it to 6,027,642.72 Can you please help with this Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Mail Merge Word Excel 2003
Hi All, Hope you are all fine. I have an issue with the Word Function Mail Merge. I have an xls with columns Adress Cust Name Invoice Amount Date. When I m doing the Mail Merge the Number Format is as below ; 6027642.719997 I want to change it to 6,027,642.72 Can you please help with this Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Mail Merge Word Excel 2003
Hi Dilip, It doesn t wotk it comes back when merging 6027642.719997 2009/6/25 Hi Nourredine, Try changing the number format in MS Excel itself. To achieve this, Go to Format - Cells - On the Number tab, choose number with two decimal places and check Use 1000 Seperator (,). After changing the number format, continue with your mail merge. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jun 25, 2009 at 6:48 PM, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are all fine. I have an issue with the Word Function Mail Merge. I have an xls with columns Adress Cust Name Invoice Amount Date. When I m doing the Mail Merge the Number Format is as below ; 6027642.719997 I want to change it to 6,027,642.72 Can you please help with this Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---