If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
captalize the letters in the Particular coloumn
how can i captalise the letters in the particular column of excel worksheet.
can it be done through only excel, but not vb programming. Thanks in advance. Regards Neelakanta |
#22
|
|||
|
|||
captalize the letters in the Particular coloumn
Without VBA you will need a helper column.
=UPPER(A1) Copy down as far as needed. Gord Dibben MS Excel MVP On Thu, 29 May 2008 08:55:01 -0700, Neelakanta wrote: how can i captalise the letters in the particular column of excel worksheet. can it be done through only excel, but not vb programming. Thanks in advance. Regards Neelakanta |
#23
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
hey guys can any one help me?(of course it is not a excel question) My drives are not openinin. if i double click on my drives an "open with" window opens. I know that it is a virus. Can u send the free link of the anti virus software that removes this virus? Thanks in advance. Neelakanta. |
#25
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
If it is just for display purposes then Custom format the cells, (Highlight
the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#26
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Thanks again!!!
"Sandy Mann" wrote: If it is just for display purposes then Custom format the cells, (Highlight the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#27
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
You are very welcome.
-- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Thanks again!!! "Sandy Mann" wrote: If it is just for display purposes then Custom format the cells, (Highlight the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#28
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
How about this one... I need to number 0001 to 1500 only in groups of 5. iE:
0001,0002,0003,0004,0005,0751,0752,0753,0754,0755, 0006,0007,0008,0009,0010,0756,0757,0758,0759,0760. ...all the way to 1500. What formula or fill series will make this work? "Sandy Mann" wrote: You are very welcome. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Thanks again!!! "Sandy Mann" wrote: If it is just for display purposes then Custom format the cells, (Highlight the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#29
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
What is the logic in deciding that
0751,0752,0753,0754,0755, comes between 0001,0002,0003,0004,0005 and 0006,0007,0008,0009,0010 ? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news How about this one... I need to number 0001 to 1500 only in groups of 5. iE: 0001,0002,0003,0004,0005,0751,0752,0753,0754,0755, 0006,0007,0008,0009,0010,0756,0757,0758,0759,0760. ...all the way to 1500. What formula or fill series will make this work? "Sandy Mann" wrote: You are very welcome. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Thanks again!!! "Sandy Mann" wrote: If it is just for display purposes then Custom format the cells, (Highlight the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#30
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Well, it is a crazy job that I'm numbering in another program and I need the
first five numbers 1-5 lined up on the left side of the page, next sheet is to have the next five numbers 6-10 all the way to 750. The the other half of the page will have numbers 751- to 755 on the first sheet. So I'm trying to print 1-5 and 751 to 755 on the first sheet, 6-10 and 756 to 760 on the second sheet etc. "Sandy Mann" wrote: What is the logic in deciding that 0751,0752,0753,0754,0755, comes between 0001,0002,0003,0004,0005 and 0006,0007,0008,0009,0010 ? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news How about this one... I need to number 0001 to 1500 only in groups of 5. iE: 0001,0002,0003,0004,0005,0751,0752,0753,0754,0755, 0006,0007,0008,0009,0010,0756,0757,0758,0759,0760. ...all the way to 1500. What formula or fill series will make this work? "Sandy Mann" wrote: You are very welcome. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Thanks again!!! "Sandy Mann" wrote: If it is just for display purposes then Custom format the cells, (Highlight the calls then select Format Cells Custom ) as 0000 then numbers will then be displayed with leading zeros if there are fewer digits. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Sandy, this formula worked great for my last job, but now i need to number in triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros and I need them to be there. I have tried to format the cells to text but then this formula does not work. Can you help me out with this one? "Sandy Mann" wrote: You're very welcome, glad that it worked for you. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... YEA!!!!!!!!!THANK YOU!!!! Wish I sould have discovered this group a couple days ago "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message news Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
Thread Tools | |
Display Modes | |
|
|