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,
Hi
Please review and do let me know if anything else required.
Regards
DD
On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote:
> Hi Experts,
>
> I am stuck with one problem. I have one file which have numbers in it. but
> while capturing they got stored as Text.
>
> Now i want any formula to co
Hi,
Please review and revert if anything else required.
Regards
DD
On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote:
> Hi Experts,
>
> I am stuck with one problem. I have one file which have numbers in it. but
> while capturing they got stored as Text.
>
> Now i want any formula to convert in
Hi Dear ,
I have done whatever i understand. if you found incorrect let me know with
some more clarification.
On Mon, Oct 24, 2016 at 4:38 PM, Hilary Lomotey wrote:
> Use Pivot Tables
>
> illustration attached
>
> On Fri, Oct 21, 2016 at 10:37 PM, Deepu Dubey wrote:
>
>
Can You share data ??
On Thu, Oct 13, 2016 at 10:52 PM, Maju wrote:
>
> hello All,
>
> Please I need some help with writing a macro or using excel formula to get
> the sum of the data. I am working with a large set of data. It runs up to
> more than column CC.
>
> I will be able to continue onc
Hi Hemant,
Can u send your file then i can help you I am also working on the same
and its already done.
Regards
Deepu Dubey
On Tue, Oct 18, 2016 at 6:14 AM, carder007 express
wrote:
> website: carder007.express (ICQ:661918036) (yahoo:carder.007@ yahoo. com)
>
>Hello c
Hi,
What equation you need?? elaborate
On Tue, Oct 11, 2016 at 12:51 PM, wrote:
>
>
> Need a help in formating an equation for the nested if..
>
> --
> 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 @
Thanks a lot Abhinav
you saved a lot of time of mine.
On Monday, July 11, 2016 at 7:15:09 PM UTC+5:30, Abhinav Sah wrote:
>
> Hey Dipu
>
> I add code to your new Delhi workbook and give button name populate Data .
> as you click the button it will ask the location of Mastersheet workbook.
Replace =vl+VLOOKUP(E2,B2:C339,2,FALSE)
first of all on this point, vlookup will not work, use instead Index and
match* =INDEX(B1:B339,MATCH(E2,C1:C339,0))*
*Regards*
*Deepu*
On Friday, 17 June 2016 12:52:48 UTC+5:30, vikas khen wrote:
>
> Hi all,
>
>
>
> Need your help
Hi Guys,
***Please revert***
On Wednesday, June 29, 2016 at 11:05:34 AM UTC+5:30, Deepu Dubey wrote:
>
> Hello *innovators*,
>
>
> I am having an issue, mentioned below:
>
> *Attachments(Zip):*
> *1.Master Sheet*
> *2.New Delhi*
> *3.Srinagar*
>
>
> *In M
Hellos,
Can u provide detailed info about JD's, Company info and Qualification n
all for freshers.
.
Regards
deepu dubey
On Thursday, June 23, 2016 at 9:34:47 PM UTC+5:30, Excel Guru wrote:
>
> Position: Backend (audit analyst /data analyst)
>
> Location: Gurgaon
>
&
++Adding Excel File
On Sat, Jun 18, 2016 at 10:44 AM, Deepu Dubey wrote:
>
>
> Hi Guys,
>
> I have a pdf file which need to be update on daily basis in an excel
> file(Attached).
>
> I have to update only one thing from pdf file.
> 1. Occ% column
>
> Can we
Hi Guys,
I am Deepu Dubey, working as Team lead-MIS in The Lalit Hotel Group, having
experience of 3 years in field of MIS. My interest are learning new things
on each day and i am music freak. I 24yrs old.
On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey a
Hi Tom,
Just want to ask you before I answer to your query.. How would you
differentiate between an Excel file and Text file if you don't save
them with file extensions..??
Answer: Every operating system use file extensions to recognize
different types of files, so you have to save your every Tex
Hey Buddy,
For MS-Access related queries you can search on
www.access-programmers.co.uk/forums,
it's a good forum...
You can also make GUIs in MS-Access...
Regards
Deepak
On Nov 22, 2:02 pm, amrahs k wrote:
> Dear Team,
>
> Can any one please suggest me that how to connect MS - Access databas
Would suggest you to search for other options...
But you can perform such calculations using VBA...
Sub Example()
Dim x As Double, y As Double, z As Double
x = 1E-19
y = 1E-20
Range("A2").NumberFormat = "0."
Range("A2").Value = Format(x + y, "0.")
End Sub
Well, I don't think you're on right way..If you'll look at the code
which I'd posted earlier, you'll find it is very easy to do so...
Previous Code..
Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0,
IconLabel:="Sample").Se
Hi Prathap,
You can use the following code to embedd emails in an excel worksheet
as object...
Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0,
IconLabel:="Sample").Select
Regards
Deepak
On Nov 14, 2:59 pm, Prathap wrot
Hi Maulik,
Below is the code that you're looking for...
Insert a module in your workbook and paste the following code and run
it...
---
D
Hi Friends,
Recently I've installed MS-Excel 2003 application on my system however
I already MS-Excel 2007 on my system, now I can use both the versions,
however I've noticed while developing a code that I'm not able create
objects of other applications in MS-Excel, i.e., I's writing a code to
con
Hi,
If it is in your reach than please think about this.. Most of the time
in a day I spend in my office, where I cannot access to Gmail but can
open Google Groups, whenever i get free time I try to solve queries
posted by other members, sometimes I get solutions and sometimes not
because of some
Well... The file is working fine in... you just need to save the
workbook before you open it.. So select 'Save' option instead of
'Open' (to directly open the workbook), I've used dynamic ranges for
charts, that might be the reason for why its not working...
Best of Luck... :-)
Regards
Deepak
On
Can you please elaborate?? What exactly you want to do..?? It'll be
helpful if you can provide any demo workbook..
Regards
Deepak
On Sep 7, 6:17 pm, Shankar Bheema wrote:
> Hai all
>
> What I have a problem is, I made an userform with all controls. But it
> wont be directly accessed without op
Though MS-Excel is not an application where you can make high class
animation.. but it depends on your creativity.. how do you utilize
your knowledge to bring such an effects in Excel.. Below is the code
that I've create, you can modify it according to your requirements,
you might want to change fo
Hi Guy's,
I've 20 command buttons on a worksheet to be used for different
purposes. I've write a code to disable and enable all of them
accordint to situations. All the buttons have a common naming
standard, e.g. "B1C1","B1C2","B1C3","B1C4","B2C1","B2C2".
I've tried with the following code..
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
Hi Kashan Abbas,
Find attached it may helps you.
On 10/13/10, Kashan Abbas wrote:
>
> Dear All,
>
>
> I have extracted a report from sap .The first column has been merged with
> multiple information for which i need separe column.
>
> The detail of information in first column is given as first
hey venkatesh,
both are one and the same wt is your excat problam in that. Can u please
eleabrate? or give me the sample file.
On 7/27/10, Venkatesh Narla wrote:
>
> Dear All,
> I have problem in 2007 Excel Pivot table
> Pls find the Pictures.
>
>
> Best Regards,
> Venkatesh narla,
> 9886058917
Hi Haseeb,
I required urgent help yar the thing is that is it possibile to give a
condition in vlookup and hlookup formulas for results for exp my data is
like this
branch branch1 branch2 branch3 branch4
branch1 5040 80
branch2 80
hi it is possible through vlookup see the attachment as i am in office in
our right now we are using MS Excel 2003 that's why i could not able to see
your file and give prompt solution but I hope this will help u if not plz
feel free to revert me.
On Tue, May 25, 2010 at 3:36 PM, Jai wrote:
>
Please send an attachment so that can helpful
On Sun, Jan 24, 2010 at 7:53 PM, Subu wrote:
> Hi Ayush and others
>
> I have a similar Raw data but with a slight difference... The prices
> per company are generally similar...and differ only in some cases
> (lest call them exceptions).
>
> I want
31 matches
Mail list logo