Try this Ram:
In Cell A1 you have value like 9.71E+15
and you want the actual value while converting into CSV then use
Range(C1).value = CDec(Range(A1).Value) and it will display as
9710
Hope this helps you.
Thanks
Kishore
On Thu, Mar 27, 2014 at 11:16 AM, ram sharma
Sorry use as below:
use Range(C1).value = CDec(Range(A1).Value) ,
On Thu, Mar 27, 2014 at 12:13 PM, ǝɹohsiʞ ʞ ʌ d kishore...@gmail.comwrote:
Try this Ram:
In Cell A1 you have value like 9.71E+15
and you want the actual value while converting into CSV then use
Range(C1).value =
Thanks All ! .. It worked
On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Hi Priyanka,
PFA
Thanks
Ashish
On 23 March 2014 17:35, Priyanka Sachdeva
priyanka.sachdeva...@gmail.comwrote:
Thanks Abhishek,
Yes, I did see the formula. Never knew it would
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ram sharma
Sent: Thursday, March 27, 2014 11:17 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to show numeric number larger than 20 digits in
CSV file
i have 20 digit number
best way to calculate date difference.
using text function.
See in attached sheet.
Divaker
On Thu, Mar 27, 2014 at 2:25 PM, Priyanka Sachdeva
priyanka.sachdeva...@gmail.com wrote:
Thanks All ! .. It worked
On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar
kumar.ashish...@gmail.comwrote:
please explain what is your purpose.
Divaker
On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 pramod...@gmail.com wrote:
Hi Excel Expert,
I am Pramod. Any have idea that any kind of book available in market for
Web scrpting by excel vba
I am newly developer of excel vba. and also suggest me
Priyanka pls find the formula
After subtracting the two dates
Day()*24+hour()*60+min()
On Mar 23, 2014 12:45 AM, Abhishek Jain abhishek@gmail.com wrote:
Yes, it will. As long as the dates and times are in correct format so as
Excel reads them as values to allow subtraction, it will work. I
Dear Vallinayagam
This sheet are password protected so I can not see the coding of copy paste.
Kindly provide the coding or file containing without password.
Thanks
Ashish
On Thu, Mar 27, 2014 at 3:28 PM, Vallinayagam nayagamva...@gmail.comwrote:
Hi,
Attached file contains a macro which
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified Date Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
1. change date format in d/mm/
2. change text to column
3.now use date function to combined date again
Divaker
On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear experts,
We have givne below date format how to convert right format of date like
From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com]
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified
i means to say that u have know of vba excel web scrapting book .
i want to learn . web scrapting .
On Thu, Mar 27, 2014 at 3:21 PM, Divaker Pandey divake...@gmail.com wrote:
please explain what is your purpose.
Divaker
On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 pramod...@gmail.com
Dear experts,
We have given below date format how to convert right format of date like
13-Jan-2014
TT Modified Date Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
From:
Yes abhi...it shld be in vba excel. Pls help
On 26-Mar-2014 3:30 PM, Abhishek Jain abhishek@gmail.com wrote:
Does it have to be Excel VBA?
I am sure there are many FTP clients that support automated and scheduled
transfers (upload or download). If you want that I can look into some.
Please provide more info or screenshot of the screen where you have to
input the date generating the report.
Regards, Abhishek
On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Yes abhi...it shld be in vba excel. Pls help
On 26-Mar-2014 3:30 PM, Abhishek Jain
Hi
You can format cell as DD-Mmm- or
you can use formula =text(ref,DD-Mmm-) where ref is your reference
cell.
Thanks
On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear experts,
We have given below date format how to convert right format of
Hi all,
Can someone tell me why i am getting this error---The sendusing
confugration value is invalid.
i am working on access version 2010.and using this code.
Sub sendmail()
Dim imsg As Object
Dim iconf As Object
Dim flds As Object
Dim schema As String
Dim stremailId As String
Dim strpassword
Hi Team,
I need to extract only the text from the alphanumeric string, can you
please help me with a formula.
Sample data attached
12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De
Regards,
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi,
i am stuck on my project, an i am still a noob on VBA :P
i have a userform with 4 textboxes and a combobox with 5 options that link
each one to 5 sheets.
Sheets (A,B,C,D and E)
Combobox with options ( 1,2,3,4 and 5)
textboxes (textnorth, textsouth,textwest and texteast)
when i choose
No abhi...since its official... Am unable to share...
On 27-Mar-2014 6:00 PM, Abhishek Jain abhishek@gmail.com wrote:
Please provide more info or screenshot of the screen where you have to
input the date generating the report.
Regards, Abhishek
On Thu, Mar 27, 2014 at 5:41 PM, Prabhu
Ashish,
The code works great!!! How could it be modified to create a new Excel
document for each Word table discovered? Kindly advise. Thank you,
Michael
On Wednesday, October 2, 2013 1:09:44 AM UTC-4, ashish wrote:
try this
Sub import_word_table_to_excel()
Application.DisplayAlerts =
PFA,
On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow lucky60...@gmail.comwrote:
Hi Team,
I need to extract only the text from the alphanumeric string, can you
please help me with a formula.
Sample data attached
12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De
Regards,
You may please contact me via chat.
Thanks
On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
No abhi...since its official... Am unable to share...
On 27-Mar-2014 6:00 PM, Abhishek Jain abhishek@gmail.com wrote:
Please provide more info or screenshot of the
A sample file would help understand better.
Thanks.
On Thu, Mar 27, 2014 at 8:28 PM, Tommy nunofilipene...@gmail.com wrote:
Hi,
i am stuck on my project, an i am still a noob on VBA :P
i have a userform with 4 textboxes and a combobox with 5 options that
link each one to 5 sheets.
Yea sure...please let me know your feasible time to contact.
On 27-Mar-2014 11:32 PM, Abhishek Jain abhishek@gmail.com wrote:
You may please contact me via chat.
Thanks
On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
No abhi...since its official... Am
If you'd add me on chat, you will know when I am online.
PS: The group doesn't need to be bothered about it, so let's just keep it
between us.
Thanks regards,
Abhsihek
On Fri, Mar 28, 2014 at 12:31 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
Yea sure...please let me know your feasible
Hi All,
Pls fin above attached sheet in which Query sheet when i type any word
related to Item code ELEC0001 (Kindly see the master sheet) it will search
the Item Name automatically. But when i put bulb it's not showing any vale
as well as Item name also.
hence request you to kindly help me on
SImple and good suggestion.
On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote:
PFA,
On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow
lucky...@gmail.comjavascript:
wrote:
Hi Team,
I need to extract only the text from the alphanumeric string, can you
please
If you know which cells to copy, use this:
Sheets(Sheet1).Select
Range(A2:B20).Select
Selection.Copy
Sheets(Sheet2).Select
Range(A2).Select
ActiveSheet.Paste
On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote:
I have a database and want to populate data into cells
29 matches
Mail list logo