Re: $$Excel-Macros$$ excel help me

You can use left or right function by converting number to text.. On Jan 6, 2018 21:26, "Deepu Raj" wrote: > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ excel help me

how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing using excel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ EXCEL HELP

Sir , I have entered values 200 and o in one single column and i want generate a report how many 200 and how many 0 are there in the same column.please sir reply quickly ...it's urgent... -- Tarun Mondal Postal Assistant Katwa Head Post Office Burdwan,West Bengal (9474810276) -- FORUM RULES

Re: $$Excel-Macros$$ EXCEL HELP

Dear Tarun, Please use.. =COUNTIF($E$1:$E$19,0) =COUNTIF($E$1:$E$19,200) On Thu, May 31, 2012 at 11:46 AM, Tarun Mondal tarunmondal1...@gmail.comwrote: Sir , I have entered values 200 and o in one single column and i want generate a report how many 200 and how many 0 are there in the same

$$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national -

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

*=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish narbhaviwithsatishku...@gmail.comwrote: Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs,

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

If you insist on using your original formula, try a more lengthier *=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60* But *=G91*1440 will give the same answer* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko samde...@gmail.comwrote:

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Hi Kris, I don't have your code, Can you please forward? Thanks, Amar On 09/02/2012, Kris krishnak...@gmail.com wrote: Hi Have you tred mine ? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Dear Amar, Use below code with little bit correction in red color This code has been modify as per Krish's solution. Hope it will help to you See attached sheet... Dim IFileName As Variant Dim SFileName As Variant Public Sub Lfile_Name() IFileName = Application.GetOpenFilename(Excel Files

$$Excel-Macros$$ Excel Help - using value of one procedure into other

Hi Team, I would like to know if I can use the value of one procedure as input to the other procedure. For example: I have a user form, it has two command buttons, the first one is requesting for a file location(address/path) and the second does also requesting another file location

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Dear Amarender, Please use it.. Public Sub Lfile_Name() Dim IFileName As Variant IFileName = Application.GetOpenFilename(Excel Files (*.xls),*.xls) MsgBox IFileName End Sub Public Sub SFile_Name() Dim SFileName As Variant SFileName = Application.GetOpenFilename(Excel Files (*.xls),*.xls) MsgBox

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Hi Noorain, I'm getting error ... Can you please try your code and check? thanks, Amar On 08/02/2012, Kasireddy Amarender kassi.re...@gmail.com wrote: Thanks Noorain! Simple and Superb! On 08/02/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amarender, Please use it..

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Hi Have you tred mine ? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2)

Re: $$Excel-Macros$$ Excel help

i think mr. bhanu needs 000999 tobe 999 not 00999 On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ viper@gmail.com wrote: if your data in a1 type the below formula on anywhere in the same worksheet =IF(AND(ISTEXT(A1),LEFT(A1,1)=0),RIGHT(A1,LEN(A1)-1),A1) -- *Thanks Regards Thamu *

$$Excel-Macros$$ Excel help

Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell. Regards ,- bhanu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Excel help

run this macro Sub RemoveAllZeros() Dim xCell As Range For Each xCell In ActiveSheet.UsedRange xCell = Replace(xCell, 0, ) Next End Sub since you ask for REMOVING ZERO IN EVERY CELL 1500 will be 15 2100500 will be 215 and so on On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash

Re: $$Excel-Macros$$ Excel help

Please attach file, so see what you need There are many ways, row or column or range I answer what you need to pair 2011/4/3 bhanu prakash bhanu...@gmail.com Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell. Regards ,-

Re: $$Excel-Macros$$ Excel help

Hi Use =SUBSTITUTE(A1,0,) On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote: Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell. Regards ,- bhanu --

Re: $$Excel-Macros$$ Excel help

u can use the following formula =SUBSTITUTE(A1,0,) (where Cell A1 is target data) Regards, Dhananjay On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote: Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell.

Re: $$Excel-Macros$$ Excel help

Hi Bhanu, Select all the cells where you want to remove zeros and select control + H, and type 0 and replace with blank and then click on* Replace All.* * * * * Thank you, Shreedar On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote: Hi - need it help excel. Removing zeros

Re: $$Excel-Macros$$ Excel help

Guys thanks a ton for responses ,i need to remove only first letter in cell if it is zero in alpha numeric data - regards - bhanu On 04-Apr-2011 3:45 AM, STDEV(i) setiyowati.d...@gmail.com wrote: run this macro Sub RemoveAllZeros() Dim xCell As Range For Each xCell In

Re: $$Excel-Macros$$ Excel help

then the macro should be modified like this Sub RemoveLeadingZeros() Dim xCell As Range, i As Integer, s As String For Each xCell In ActiveSheet.UsedRange s = CStr(xCell) For i = 1 To Len(xCell) If Mid(xCell, i, 1) = 0 Then s = Right(s, Len(s) - 1)

$$Excel-Macros$$ Excel Help

Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any

Re: $$Excel-Macros$$ excel help

Hi Preeti, Vlookup requires col_index_num and range_lookup to function properly, If reqd., instead of Vlookup you can use Index, Match, Offset, SumIf, Sumproduct etc as well. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com

$$Excel-Macros$$ excel help

Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- Some important links for

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

Hi Siti, Thanks for your reply, But the below said is not working Below is the recorded code for removing pagebreaks ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 is any other code to remove page breaks *I need to set the Page break to end of the used last column.*

$$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

Hello Friends, Can anyone help me to remove Page Breaks in Excel sheets Using VBA code. Thanks, N.Sundarvelan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

I think, removing VPageBreaks and HPageBreaks can be done by setting FitToPage /Wide/Tall properties to : 1 Sub ClearPgBreasks() With ActiveSheet.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With End Sub On May 12, 8:33 pm, Sundarvelan N

$$Excel-Macros$$ EXCEL HELP

HI, I HAVE 500 PERSONS NAME IN SHEET1. LIKE:-BOX BAT BALL BLACK AXE IN SHEET2 AND SELECT CELL A1 WHEN I ENTER FIRST LETTER (AVAILABLE IN SHEET1) LIKE B COLUMN C SHOWS LIST OF AVAILABLE NAMES STARTING WITH B-LETTER.ITS LIKE GOOGLE

Re: $$Excel-Macros$$ Excel Help

dear shiv i think you can use a simple way pivot table and pivote grapgh. if more help required please send me me your sample sheet,and offcourse image file for required graph. hope it will help. happy to help. :) shyam On Wed, Mar 3, 2010 at 10:05 AM, Shiv Goel shivyn...@gmail.com wrote:

Re: $$Excel-Macros$$ EXCEL HELP

Hi Group, I want to learn excel macros. so can anybody have excel macro learning document for easily learning. with regards, sekhar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ EXCEL HELP

hi, Can anybody help me for writing excel macro. plz find the attached excel sheet for the problem, with regards, sekhar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ excel help

Hi, A particular sheet in excel file doesn't allow cut/copy/paste. txs -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

Re: $$Excel-Macros$$ excel help

Dear Karthik, Check if that sheet is protected. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/1/09, karthikeyan karthikeyansankar...@gmail.com wrote: Hi, A particular sheet in excel

RE: $$Excel-Macros$$ excel help

Check to see if there is a SheetActivate event macro for that particular sheet. Regards - Dave. Date: Tue, 1 Dec 2009 08:06:15 -0800 Subject: $$Excel-Macros$$ excel help From: karthikeyansankar...@gmail.com To: excel-macros@googlegroups.com Hi, A particular sheet in excel file

$$Excel-Macros$$ Excel Help

HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Excel-Help

Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~

$$Excel-Macros$$ Excel Help...

Hi Team, I have a list of numbers in an excel columns. I need to open a site and enter the numbers one by one in the search field of Open site and hit enter. I also need to capture the some information from the screen after clickling enter and then get back to the search page. Can anyone

$$Excel-Macros$$ Excel Help

I'm using excel to do weekly time sheet and I created another page/tab with in the same workbook and I'm trying to post job numbers between the two sheets. If I post a new Job number and it's not already on the control sheet I want to add, not + but include it in the job numbers. Anybody?