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
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
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
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
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 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 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:
>
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
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
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
28 matches
Mail list logo
