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