Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread NOORAIN ANSARI
Dear Ravi, see attached sheet hope it will help to you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Thu, Mar 29, 2012 at 5:37 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > Dear

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread dguillett1
Maybe you could just change the format for all Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ravi Kumar Vandavasi Sent: Thursday, March 29, 2012 7:07 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reading custom format as it appears in a

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Maries
*Ignore Previous One. Shortcut key is Ctrl + F3* ** On Thu, Mar 29, 2012 at 4:40 PM, Maries wrote: > Hi, > > Try Below, > > 1. Select Cell C1 > 2. Press Shift+F3 > 3. Give Name as cellformat Refers to GET.CELL(7,A1) > > Use the formula in C1, =LEN(cellformat) > > Regards, > > MARIES. > On Thu, M

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Maries
Hi, Try Below, 1. Select Cell C1 2. Press Shift+F3 3. Give Name as cellformat Refers to GET.CELL(7,A1) Use the formula in C1, =LEN(cellformat) Regards, MARIES. On Thu, Mar 29, 2012 at 4:34 PM, Maries wrote: > *PFA...* > > > On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi < > friendswri

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Maries
*PFA...* On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > Dear Sir, > > I have a series of Numbers where there might be less than 15 digits i.e. > custom format is used as "00" (14 instead of 15 or 16 instead > of 15). So, I need to identify

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Ravi Kumar Vandavasi
Dear Sir, I have a series of Numbers where there might be less than 15 digits i.e. custom format is used as "00" (14 instead of 15 or 16 instead of 15). So, I need to identify these numbers which are wrongly custom formatted. For better understanding, please check the attached file

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Ravi Kumar Vandavasi
Dear Sir, Please find the excel sheet attached for better understanding. Regards, Ravi Kumar On Wednesday, March 28, 2012 4:04:29 PM UTC-7, Don Guillett wrote: > Do you mean values >0 such as 2 for the last example? > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille..

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-28 Thread NOORAIN ANSARI
Dear Ravi, Please use =REPT("0",15-LEN(A2))&A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > I have an excel file each cell may have different custom formats such a

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-28 Thread dguillett1
Do you mean values >0 such as 2 for the last example? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ravi Kumar Vandavasi Sent: Tuesday, March 27, 2012 10:39 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Reading custom format as it appears in a c