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
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.
*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 these
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 talk2mar...@gmail.com wrote:
*PFA...*
On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar
*Ignore Previous One. Shortcut key is Ctrl + F3*
**
On Thu, Mar 29, 2012 at 4:40 PM, Maries talk2mar...@gmail.com 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.
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
Dear Ravi,
see attached sheet hope it will help to you.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Thu, Mar 29, 2012 at 5:37 PM, Ravi Kumar Vandavasi
friendswrite...@gmail.com wrote:
Dear Sir,
I have an excel file each cell may have different custom formats such as
000 or 0940101 or 0080100 etc. I would
like to count number of characters in each cell. If I use len() function it
retreives the length as it appears in the formula bar and not the maked
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
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 as
10 matches
Mail list logo