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? It’s
> =TIME(2,DO:IT,N:O
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 concise,
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 wrote:
> 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
> rep
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 (
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 wrote:
> *=G91*1440*
>
> Regar
*=G91*1440*
Regards,
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 4:53 PM, satish
wrote:
> 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 u
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 -
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
Hi Kris,
I don't have your code, Can you please forward?
Thanks,
Amar
On 09/02/2012, Kris 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, Urgent, Need He
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) Don'
Hi Noorain,
I'm getting error ... Can you please try your code and check?
thanks,
Amar
On 08/02/2012, Kasireddy Amarender wrote:
> Thanks Noorain!
>
> Simple and Superb!
>
> On 08/02/2012, NOORAIN ANSARI wrote:
>> Dear Amarender,
>>
>> Please use it..
>>
>> Public Sub Lfile_Name()
>> Dim IFile
Thanks Noorain!
Simple and Superb!
On 08/02/2012, NOORAIN ANSARI wrote:
> 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
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")
MsgB
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 (address/pa
i think mr. bhanu needs
"000999" tobe "999" not "00999"
On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ 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
> *
>
>
--
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
*
On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakash wrote:
> Guys thanks a ton for responses ,i need to remove only first letter in
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)
try this made some changes in the code
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
If Left(xCell.Value, 1) = 0 Then
xCell.Value = Right(xCell.Value, Len(xCell.Value) - 1)
End If
Next
End Sub
On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakas
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)" wrote:
run this macro
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
xCell = Replac
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 wrote:
> Hi - need it help excel. Removing zeros in alpha numeric da
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 wrote:
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhan
Hi
Use
=SUBSTITUTE(A1,"0","")
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote:
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
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
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
>
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 pr
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 trick
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
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
dilipa
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 e
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.*
*
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 wrote:
>
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 :
http://t
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 SEARCH
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 wrote:
> Hi
>
>
> I try to ma
2001, 2002, 2003.
same like vlookup but the result is unique then keep on adding with a comma for
that look up.
Regards,
Shan
--- On Wed, 2/10/10, ayush jain wrote:
From: ayush jain
Subject: Re: $$Excel-Macros$$ EXCEL HELP
To: excel-macros@googlegroups.com
Cc: somasekhar2...@gmail.com
Date
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 tricks
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 link
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 p
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 wrote:
>
> Hi,
>
> A particular sheet in excel file doesn't allow cut/copy
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.
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), Fr
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
--~--~-~--~~~---~--~~
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 please
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?
--~--~-
43 matches
Mail list logo
