Hi ...may be u could try thisThis file was provided by one of the excel
gurus which i have been using..hope it helps u too
formula is =text2num(cell ref)..Hope u have included the macro into excel
addins
On Sat, Aug 8, 2009 at 8:01 PM, Sabyasachi Mishra dashingsa...@gmail.comwrote:
still
Hi Prasad,
Divive the value with 1440 or (24*60) and change the cell formate ( go to
custom and make the cell format h:mm ) you will the correct result.
regards,
Idrees
On 8/9/09, Prasad Gadgil maocca1...@gmail.com wrote:
*Dear All Members,
*To calculate productivity, I need to convert
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 Format
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
=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
Can some body help in this simple problem ?
-- Forwarded message --
From: Balachander S sba...@gmail.com
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
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 maocca1...@gmail.com
*Dear All Members,
*To calculate productivity,
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 mahes...@gmail.com wrote:
Hi Sachin
Please find attach sheet this will help u, formula is =Spellnum(cell value)
On 8/8/09, sachin patil
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,
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
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 harmeet.hew...@gmail.comwrote:
made a copy of actual row and deleted the actual row afterwards.
On Thu,
Hi,
Paste this into D2, then copy down.
=IF(B2-A260,Above 60 days,IF(B2-A230,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 to
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,
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
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
--~--~-~--~~~---~--~~
15 matches
Mail list logo