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 in
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:
>
