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
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?
