It will increase length of value
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of nehal sejpal
Sent: Friday, June 17, 2011 9:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pad zeros
Put '000745689002346789
On Fri, 17 Jun 2011 0
Select the Value and Apply Custom Format "0"
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Skanda
Sent: Friday, June 17, 2011 3:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pad zeros
Hi,
How to add zeros in front of a
check out the linkS below
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
On Fri, Jun 17, 2011 at 11:24 AM, Dilip Pandey wrote:
> Hi,
>
> I would suggest to follow Microsoft online tutorials &
Hi,
I would suggest to follow Microsoft online tutorials & help OR Google
for "Excel-VBA tutorial for beginners".
Best Regards,
DILIPandey
On 6/15/11, Shaik Waheed wrote:
> Dear Experts,
>
> As I am beginner in VBA, please suggest me any institute in Hyderabad or any
> best sites which can gi
Hi Skanda,
Assuming the data provided by you is in Column A, use following formula:-
=REPT(0,9-LEN(A2))&A2
Sample worksheet is attached herewith.
Let me know if this helps.
Best Regards,
DILIPandey
On 6/17/11, Skanda wrote:
> Hi,
> How to add zeros in front of a value with varying lengths s
add ' sign before the policy id '00078999...
check the attachment
On Fri, Jun 17, 2011 at 9:07 AM, nehal sejpal wrote:
>
> Put '000745689002346789
> On Fri, 17 Jun 2011 08:08:15 +0530 wrote
>
> >Hi,� How to add zeros in front of a value with varying lengths so that the
> length of the column
Put '000745689002346789
On Fri, 17 Jun 2011 08:08:15 +0530 wrote
>Hi,� How to add zeros in front of a value with varying lengths so that the
>length of the column is 9?for instance a column policy id has values with
>varying lengths as follows:�
Policyid:�7456892346789��so i need to transform
Hi Dave,
Good Morning.
Thanks .
Regards
Kannan V
9941077703
onechennaiproperty.com
On Thu, Jun 16, 2011 at 2:06 PM, Dave Bonallack
wrote:
> Hi Kannan,
> Have a look at the attached
> Regards - Dave
>
> --
> Date: Thu, 16 Jun 2011 09:03:35 +0530
> Subject
Hi Skanda,
you can do one thing, first select the numbers and then go to
Format > Format cells > number tab > custom > 0
In case any query, please feel free to contact.
Thanks & Regards,
Manish Singh Bankoti
On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote:
> Hi,
> How to add zeros in
hi friend
my suggestion: www.excel-vba-easy.com. this site best for beginning vba
learners
thanks&best regards
XL tutor
gsha technologies
ameerpet,annapurna block, aditya enclave ,hyd
#317(third floor)
On Wed, Jun 15, 2011 at 7:12 PM, Shaik Waheed wrote:
> Dear Experts,
>
> As I am beginner
Dear Hari,
Just watch the below link video's you may get Some of basics in Excel VBA
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
Best Regards,
Venkat
On Thu, Jun 16, 2011 at 8:35 PM, Hari wrote:
>
> Dear Friends,
>Can any one please help me in *"how to learn Excel-VBA"*
Hi,
How to add zeros in front of a value with varying lengths so that the
length of the column is 9?
for instance a column policy id has values with varying lengths as follows:
Policyid:
745689
2346789
so i need to transform the above policyid to:
000745689
002346789
--
Dear John,
Please try it..
=IFERROR(ROUND(VALUE(HOUR(D18)+(MINUTE(D18)/60)),1),"")
--
Thanks & regards,
Noorain Ansari
On Thu, Jun 16, 2011 at 8:05 PM, John A. Smith wrote:
> Dear Excel Teachers,
>
> I need a formula to give me the decimal hours between two dates. I have
> at
Dear Excel Teachers,
I need a formula to give me the decimal hours between two dates. I have
attached a sample.
Thanking you in advance for your on-going help and wisdom.
John
--
--
Some important links for excel
Thank you for your help but quite simply, no! It's saving a file as
UTF8 which is a specific encoding format, supporting more characters
than other formats. Excel does not natively support UTF8 despite it
being widely used. This code will allow you to do that, which I've
now tidied up and simpli
Your code is working fine...Can you elaborate what do you want to do,
exactly?
On Jun 16, 3:11 pm, airen wrote:
> Sub bubblesort()
> Dim i As Integer, j As Integer, n As Integer, temp As Single
> n = Selection.Rows.Count
> For j = n To 3 Step -1
> For i = 1 To j - 1
> If S
Dear Friends,
Can any one please help me in *"how to learn Excel-VBA"* through some
tutorial materials as i am CA Final student.
-
Yours,
Hari.
--
--
Some important links for excel users:
1. Follow us on TWI
There is a "Custom Toolbars Button" available for the "Quick Access
Toolbar". This button has "drop-down" capability, so I assume
commands can be added to this button.
Can anyone point me to an example of how this button can be used - my
web searches have pinpointed no results.
--
-
See attached file.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : jeudi 16 juin 2011 13:02
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry-3
Dear Members,
i need the formula please..
--
Ne
recruiter id mee...@s3ci.com
or call @ 0- 8447733049
Hi,
This is regarding an urgent opening for Reporting Analyst, with one of our
reputed client.
Client: United Health Group
Location: Gurgaon
• Ensures that informational needs of our client and internal customers are
met by designing and crea
See if it help
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Thursday, June 16, 2011 4:32 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ querry-3
Dear Members,
i need the formula please..
--
Nemi Gandhi
98204 9296
Dear Members,
i need the formula please..
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Link
Many thanks Danielresult is perfect. One more querry is posted.
Please help.
On Jun 15, 2:40 pm, "Daniel" wrote:
> Maybe this file ?
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Nemi Gandhi
> Envoyé : me
Sub bubblesort()
Dim i As Integer, j As Integer, n As Integer, temp As Single
n = Selection.Rows.Count
For j = n To 3 Step -1
For i = 1 To j - 1
If Selection.Cells(i, 1) < Selection.Cells(i + 1, 1) Then
temp = Selection.Cells(i, 1)
Selection.Cells(i,
Yeah this is very useful siten quick tooo
--
--
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.l
25 matches
Mail list logo