Sorry use as below:
use Range("C1").value = CDec(Range("A1").Value) & ","
On Thu, Mar 27, 2014 at 12:13 PM, ǝɹohsiʞ ʞ ʌ d wrote:
> 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"
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
wrote:
>
i have 20 digit number in my excel sheet, but when i move this number into
another cell then it display in 9.71E+15 like this. i want to move this
number using macro programming and display excatly number not 9.71E+15
value.
how i can do this?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Thank you so much It works. I made some changes to the loops to locate
the data exactly where I wanted.
Thank you again.
On Tuesday, March 25, 2014 5:41:34 PM UTC-4, Rafael DeLeon wrote:
>
>
> Hello all,
>
> I have a SQL Server Database with a store procedure that I would like to
> displa
Hello,
I am trying to get to a point where i can run a macro or VBA script to
go through my spread sheets and look for duplicate info in three different
columns, one column at a time, find the first duplicate, move on to the
next column, check it for duplicates, move on to the next column, th
can you provide please sample file.
Divaker
On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote:
> hi everyone
>
> i have looked around most postings here but none was similar to my
> situation.
>
> i need help please, or kindly pls suggest me where i can get help.
>
> everyday i received about
hi everyone
i have looked around most postings here but none was similar to my
situation.
i need help please, or kindly pls suggest me where i can get help.
everyday i received about 100 customers' addresses. it is in 1 row for each
address, but all the address details are lumped into 1 cell.
Excel (2007) intermittently adds the full pathname of the add-in to the
function name when it's used in a cell formula. Then if the spreadsheet is
opened on another computer, even if the other computer has the add-in
installed, the function is not recognized. Any idea how to solve this?
--
Are y
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.
Regards,
Abhishek
On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote:
> Hi experts,
>
> i need your suggestions on my
Hi experts,
i need your suggestions on my new project.
*Here is my scenario:*
in our office, we have a ftp link for one application. on a daily bases i
am opening that link and entering my login id and pwd. there we have many
tabs for many reports.
am just selecting my required report and ente
Thanks a lot Jayavelu. :)
*Thanks! Indrajit*
On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN wrote:
> This is solution for State =MID((RIGHT(A17,8)),1,3)
>
> this is solution of pin code =right(right(A17,4)
>
>
> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
>
>> Hi Experts,
>>
>
This is solution for State =MID((RIGHT(A17,8)),1,3)
this is solution of pin code =right(right(A17,4)
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
> Hi Experts,
>
> Is there any way out to split up an address as per the attached file
> format!
>
> If so then please provide me the f
12 matches
Mail list logo