Hi Putta,
Try -
= substitute([cell ref],"-","")*(-1)
Thanks
Alvin
On Aug 4, 5:08 pm, Putta Madaiah wrote:
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *Original Value*
> *Required answer*
> 125756.95-
> -125756.95
Hi Wes
Not too sure what the problem is exactly as I have just used
"Data Validation"
=> "Settings"
=> "Allow " = "Text length"
=> "Data" = "less than or equal to"
=> "Length" = "7"
then tested it on a cell with custom format of "000" and it seems
to be OK.
Let me know how you go if this is
Thanks Jonell
On Tue, Aug 4, 2009 at 4:56 AM, jonell wrote:
> On Aug 2, 1:07 am, DebApriYA BiswAS <> wrote:
> > Hi Please find the attached .xls file. I'm trying to make a budget list.
> > there is a drop down menu which will indicate the month. Now what I want
> is
> > when I will chan
thnx for prompt reply
PFA an example of what I am looking for ...
Rg
On Tue, Aug 4, 2009 at 9:42 PM, Norman May wrote:
> I'm not sure if this is what you want...
> Example:
>
> ="The amount in cell A1 is "&A1&" and this will change daily."
>
>
>
> On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal
>
Hello all,
I'm attempting to have a window pop up when the user clicks a
command button on the sheet. The hurdle I have come to is drawing on
the form. I have dimensions on the sheet that I want to feed into the
"pop-up" for this sketch.
What am I missing? I can't get any shape commands to
Sending a Macro to End User within an Excel spreadsheet
Hope all is well – I have a bunch of users who receive a daily CSV
file via a sendmail account. Is there anyway that I can send them an
Excel file in the beginning so it creates a macro for formatting.
Any help would be greatly appreciated
Problem:
I want to calculate currency difference for yrs 1997-2007. Currently
this is done via:
Sheet9! below
a b c
1DateAUSUSA
2 199712 0.782 1
3 199801 0.761 1
.
.
.
n 200712
=thi
I need to retrieve stock information from a web site. (It can be any
site that provides such information - the site is not important). I
need to retrieve this information at set intervals - e.g., every 10
minutes, and record in Excel (a) the time of retrieval (b) the stock
quote (c) any other i
I'm not sure if this is what you want...
Example:
="The amount in cell A1 is "&A1&" and this will change daily."
On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal wrote:
>
> Hi,
>
> I have to delete so many cell entries in my daily job and input those
> cell entries in the comments with some text
Hi,
I have to delete so many cell entries in my daily job and input those
cell entries in the comments with some text. Any shortcut for the same
would be helpful ...
Rg
--~--~-~--~~~---~--~~
Try : COUNTIF formula
Rg
On Tue, Aug 4, 2009 at 6:14 PM, shivashankar
katageri wrote:
> Dear all,
>
> any body help me to sort out the with attached sheet
> --
> Thanks & Regards
>
> Shivashankar.C.Katageri.
>
>
> >
>
--~--~-~--~~~---~--~~
Hi All,
Please let me know if anyone know about MS Access or provide me any link,
where i can find help.
Regards,
Suresh
--~--~-~--~~~---~--~~
--
Some important links for excel users:
I've done that before too...
but in earlier versions of excel (I haven't tried it again in 2007)
if you printed the spreadsheet with the highlighting,
it would print the entire line.. to column "IV".
so, I shied away from it and got used to only highlighting
the columns I'm using.
Plus, selecting
That worked beautifully! Thanks!
What if I wanted it to populate a named range? Is that possible.
On Aug 3, 1:18 am, msakibkhan wrote:
> Dear Jake !
>
> try the following solution:
>
> Private Sub cmdOK_Click()
> Sheet2.Range("A4:A1000").ClearContents
> For x = 0 To ListBox2.ListCoun
Hi there,
There is an easier way to do this as well with a single line of code
in the Worksheets OnChange event,
Target.EntireRow.Select
It works pretty well.
Cheers
On Aug 4, 2:12 pm, Paul Schreiner wrote:
> I don't know that there is any OPTION for this, but
> I have done it before with a
Dear all,
any body help me to sort out the with attached sheet
--
Thanks & Regards
Shivashankar.C.Katageri.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
Hi Puttam,
Same can be done with ASAP Utilities.
Text-->Reverse text in selceted cell.
Hope this will saolve ur problem.
Rgds,
Mahender Bisht
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah wrote:
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against O
Hello,
I am searching for a way to attach a word file in a mail merge based
on an excel list. I come a long way but am stuck. Can someone please
help me tweak the code to get the job done?
Here is the code I came up with so far.
Sub Macro1()
Dim OutApp As Object
Dim OutMail As Object
Hello,
You can use the following formual to achieve the required:
="-"&MID(B26,1,FIND("-",B26)-1)
The formula will add a "-" sign infront of the number extracted from original
value cell with suffixed "-" omitted.
Kind regards.
Serghei.
Date: Tue, 4 Aug 2009 14:38
THanks Dave, this is working fine for me..
Rgds- Putta
On Tue, Aug 4, 2009 at 5:09 PM, Dave Bonallack wrote:
> Hi,
> Try this formula in B2, and copy down.
>
> =LEFT(A2,LEN(A2)-1)*-1
>
> You will have to format the cell to Number, 2 decimal places.
> Regards - Dave.
>
> ---
hi
use this formula in B1 cell.putting value in a1 cell.
=IF(ISERROR(FIND("-",A1)),A1,CONCATENATE("-",SUBSTITUTE(A1,"-","")))
On 8/4/09, Putta Madaiah wrote:
>
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *Origi
I can advise one thing:
First, find (Ctrl+F) "-" and replace with blank. Then you will get
positive values.
Second, you multiply with -1.
On 8/4/09, Putta Madaiah wrote:
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *O
Hi,Swanand/Vivekplease
find the attached copy,hope this explains how I required,
Advance thanks,
regards,
Shiva
On Mon, Aug 3, 2009 at 3:12 PM, vivek agrawal wrote:
> Hi Shivashankar
>
> cal u please clarufy in which structure or format do you require the result
> in
>
> Thanks and Regards,
>
Hi,
Check this one if its ok for u
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Putta Madaiah
Sent: 04 August 2009 PM 02:39
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula-Replacing Minus Symbol
I don't know that there is any OPTION for this, but
I have done it before with a MACRO.
but there are a few "tricks"
I use the Worksheet_SelectionChange event.
First, record a macro in which you clear all formatting (highlighting)
then "highlight" the row you wish to highlight.
this will get you
Remember that Excel stores numbers as numbers.
it may DISPLAY them in all variety of things.
For instance, the number 109.123456
Could be SHOWN as:
109.123456
109.12
109.1234560
4/18/1900
2:57:47 AM
4/18/00 2:57 AM
the letter "m"
Each of these LOOK different, but are actually the same numb
Hi,
Try this formula in B2, and copy down.
=LEFT(A2,LEN(A2)-1)*-1
You will have to format the cell to Number, 2 decimal places.
Regards - Dave.
Date: Tue, 4 Aug 2009 14:38:34 +0530
Subject: $$Excel-Macros$$ Formula-Replacing Minus Symbol
From: puttamada...@gmail.com
To: excel-macros@googlegroup
Hi All,
Can any one tell me the formula to get the value as in Required answer as
against Original Value.
*Original Value*
*Required answer*
125756.95-
-125756.95
75845.25-
-75845.25
123.38-
-123.38
10.15-
-10.15
158946-
-158946.00
856456.25-
-856456.25
Regards- Putta Madaiah-
Dear All,
Is there any option that when I select a cell in the sheet, the whole row
corresponding to that cell is highlighted.
In the attached example I have selected cell C7. Required: the whole row 7
should be highligted.
Thanks and regards,
Sheyn
--~--~-~--~~~---~--
You can only place the radio button captions to the left or right of the
option indicator. The Alignment property does that.
When you have placed the labels (with caption) above the option button, you
can use some code like -
Private Sub OptionButton1_Enter()
Label2.BorderStyle = fmBorderSty
30 matches
Mail list logo
