Is there is anyway to use values as range in formula.
Or is there is anyway to change values in range.
Don't think for a vba solution i know the vba to solve this but i need it using
excel worksheet functions.
Thanks and Regards
Sandeep
--~--~-~--~~~---~--~~
Its very easy u can use following functions (Enter 536 in F-22).
=TIME(0,F22,0)
Regards,
Date: Sun, 9 Aug 2009 10:23:33 +0530
Subject: $$Excel-Macros$$ How to convert number into hrs & min.
From: maocca1...@gmail.com
To: excel-macros@googlegroups.com
Dear All Members,
T
Hi All,
I need some help from you all. I have to do lot of translation.
Currently what I am doing is this;
1) I write my msg in English in Excel, what I have found out is that
for near accurate translation you need to break your msg lines of 10
-15 words so
2) I break my msg into various parts a
Hi,
Paste this into D2, then copy down.
=IF(B2-A2>60,"Above 60 days",IF(B2-A2>30,"31-60 days","0-15 days"))
Regards - Dave.
Date: Sun, 9 Aug 2009 15:02:05 +0530
Subject: $$Excel-Macros$$ Calculate Range of Days
From: mahes...@gmail.com
To: excel-macros@googlegroups.com
Dear All
i want
Hi Jeffrey,
Are you saying that you've written a custom function in VBA and when
you use the function in the spreadsheet it references the drop down
list? If this is the case your function should update when you change
the drop-down list.
If you're using a subroutine, I'd suggest using the 'Ch
The original file has 48000 line items...isnt there any way so that i can
remove the filter from the same file without copy-paste.
On Fri, Aug 7, 2009 at 2:29 AM, Harmeet Singh wrote:
> made a copy of actual row and deleted the actual row afterwards.
>
>
> On Thu, Aug 6, 2009 at 12:01
I'm using sendkeys to send some numbers to a java based back office
system. It works perfectly on sending the numbers however I'm looking
to create a text box on a user form so that the user can input the
numbers to send to the back office system.
Application.SendKeys ("12345"), True
Could someo
Hat's off Master.
It's working very fine. Thanks for your valuable support.
One more question about the custom format, How to improve custom formatting.
Thanks again with waiting for your reply with detailed help about "CUSTOM
FORMATTING" (a very useful option/function in Excel).
Regards,
Dhanan
dear mahesh
this workbook has expired and after that excel close the file
vikas, delhi
9958646556
On Sat, Aug 8, 2009 at 5:28 PM, mahesh parab wrote:
> Hi Sachin
>
> Please find attach sheet this will help u, formula is =Spellnum(cell value)
>
>
>
>
>
>
>
>
> On 8/8/09, sachin patil wrote:
>>
Use the Formula
=INT(A4/60)&"Hr"&" "&(((A4/60)-INT(A4/60))*60)&"min"
replace A4 by the cell refrence in your sheet.
It can be modified further if you need, just drop me a mail
Thanks n Regards
Gaurav Banerjee
2009/8/9 Prasad Gadgil
> *Dear All Members,
>
> *To calculate productivity, I need
Can some body help in this simple problem ?
-- Forwarded message --
From: Balachander S
Date: Thu, Aug 6, 2009 at 10:26 PM
Subject: $$Excel-Macros$$ Trouble in changing url in Macro
To: excel-macros@googlegroups.com
I am trying to change the date in the macro for url address in
=A1/(24*60) then change the format it in Time format
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Prasad Gadgil
Sent: Sunday, August 09, 2009 10:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to convert number into hrs &
Dear Dhananjay
Please find attached the solution.
1) For the rounding of the numbers, I have used : =ROUND(B2,-1) in the
Column C.
2) For the formatting of the numbers I have used the following custom format
:
[>=1000]##\,##\,##\,###.00;[>=10]##\,##\,###.00;#,##0.00
Please let me know if
Hi,
Highlight the entire column - lets suppose it's column A.
Then put the following into the "Formula is" part in the Conditional Format
dialog box:
=LEN(A1)<>10
Set the desired format.
Regards - Dave.
> Date: Sat, 8 Aug 2009 08:12:55 -0700
> Subject: $$Excel-Macros$$ Simple question about Fo
14 matches
Mail list logo
