;
>> 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 custo
lle...@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 cell
I have an excel file each cell may have different custom formats such as
"000
*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
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
*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
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
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 cell
>
> I have an excel file each cell
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
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 i
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
c
10 matches
Mail list logo
