How to convert exponential data into number for the downloaded excelsheet

Advertisement

Hi
I have downloaded one field data i.e. having char of 50,  into excel sheet and it is displaying as  exponential in the excel sheet. 
The data numbers should display as text only i.e 1236547896321 and not exponential
Is anyone can tell how we can do this
Thanks
Pallavi

Advertisement

Hello Pallvai,
The problem of exponential is with the excel. Excel converts the large numbet into exponential.
To avoid this you can make the number into text then excel won't convert it into exponential.
For that you can do a simple trick. Just prefix a single quote ( ' ) in the field.
eg:
field = 1236547896321.
then,
constants c_quote type c value '''.   "<-- single quote
concatenate c_quote field into field.
" This will make the EXCEL to consider this field as text not number and hence it will not be considered
" as exponential.
Hope this solves your problem.
Regards,
Sachinkumar Mehta

October 11, 2015

How to convert exponential data into number for the downloaded excelsheet

Hi I have downloaded one field data i.e. having char of 50,  into excel sheet and it is displaying as  exponential in the excel sheet.  The data numbers should display as text only i.e 1236547896321 and not exponential Is anyone can tell how we can d

How to convert .MOD files into .DV for iMovie import

I am urgently (and desperately) trying to import some .MOD files into iMovie 09 for editing. They were made on a JVC cam, but I only have them on HDD now. I tried renaming files to .avi, but still cannot import them. I used Handbrake to convert to mp

How to convert JPEG Files into Streams for Darwin Streaming Server?

Hi! Is there any possibility to convert JPEG Files locatet in a Folder into a Videostream for the Darwin Streaming Server, like Quicktime Broadcaster does with my iSight Video??? I know I can convert JPEGs into Movies using QuickTime Pro, but that is

How to execute a same sequence number for the resulting dynamic rows

Hi friends, I have a sequence and trigger(which will fire id for each and every row insert). My scenario is, If i update more than 5 rows at a time means, i need to set a same sequence number example(1) for all the 5 rows. Next time, if i update anot

How to convert xml data into html format in bpel

Hi , Can any one tel me how to conevrt xml into html in oracle bpel. Does bpel support this functionality or not. Regards, Ana Edited by: user10181991 on Apr 5, 2009 11:16 PMAna, We are doing the same thing--using one variable with the schema as the

Convert exponential to whole number

Hi all, I have a small question. How to convert exponential value into whole number ThanksFm QSS0_FLTP_TO_CHAR_CONVERSION or data:lv_whole_no type i. lv_whole_no = lv_exp_no. write  lv_whole_no.Read other 4 answers

I need a formula to convert a date into an integer (for use in Lookout)

I have a DATA logger with the following: 40001 = 4 (2004) 40002 = 2 (February) 40003 = 5 (5th) 40004 = 13 (1:00pm) 40005 = 12 (12 minutes) Lookout requires a date that it understands (eg. January 1, 1900). All I need is a basic formula to convert the

How to convert a data set into a xml data and vice versa

i am new to oracle with xml.. my aim is to convert a data set into a xml data and vice versa.. my work is as follows... my query: select rggpk,rggcode,rggname from ms_regiongeo to convert a data set into a xml* select XMLType(trim(replace(dbms_xmlgen

Step- by- Step on How to Load Excel data into Crystal Reports?

Hi Friends,                   Can anyone send me a Step- by- Step on How to Load Excel data into Crystal Reports? Pls help me. Thanks in Advance. VijayIt's also important to 'prep' the excel file prior to connecting to it. Give the data tab a meaning

How do I unregister a serial number for LR and replace it with another one?

Hello I got LR3 with my Leica M9. Now I sold my M9 and I'm waiting for the next Leica M to arrive in the next few months. Since LR is more or less part of the Leica-Software, I sold it with it and for the time, while I waiting for the next M, I bough

Is it possible to convert LabView data into OLE variant?

Hi. I'm using Activex Data Objects (ADO) to communicate with MySQL. Some ActiveX methods give OLE variant output, with "Variant Type" like "VT_ARRAY|VT_UI1", "VT_UI1" or "VT_BSTR". With some deduction and trial and

How to convert HL7 file into an XML

Hi All, I am new to HL7,can any one tell how to convert HL7 file into an XML.Give sample demo or related links. My sample HL7 file is as follows how can I convert. FHS|^~\&||Tax ID123^Lab Name123^L|||201110191435||HL7.txt||1234567|123|| PID|seqno|123

Convert from date to number

Hi, I want to convert from date to number. How can I do? Thanks [email protected]That rather depends on what sort of number you want. You can probably get what you want by a combination of to_char and to_number.Read other 2 answers

How to generate BP number for the employee (ECC to CRM) ...

Hi all, can any one give solution for ,how to generate BP number for the employee from ECC to CRM other than active status,as i downloaded employee data from ECC to CRM through ALE/IDOC,as only active employment status employees are got BP number gen

How we export report data into excel in report 10g

hi can any one tell me how we export report data into excel in report 10g (except spreadsheet)We can use TEXT_IO PackageRead other 2 answers

This is related to UCS-D : How to populate inventory data into lovs

This is related to UCS-D : How to populate inventory data into lovs I think you need to update the database from the applet. Then refresh the page to sync with values in the database. --Prasanna                                                        

HOW DO I GET A SERIAL NUMBER FOR LOGIC PRO IF LOST MINE ?

How do i get a serial number for logic pro ?  i purchased it so long ago and i just cleaned off my computer and re-installed mountain lion . When i did an erase and archive i forgot to look to see the serial number . Now when i go to launch it it ask

How to convert database table into xml file

Hi. How to convert database table into XML file in Oracle HTML DB. Please let me know. Thanks.This not really a specific APEX question... but I search the database forum and found this thread which I think will help Exporting Oracle table to XML If i

How to load image data into cube?? Is it possible??

How to load image data into cube?? Is it possible?? Any sugession??Hi Andre, Document will be of ASCII characters right?? but image data will be in binary format. as per database concept it is stored as binary large object. But in datawarehousing the

HT204382 How to convert VOB files into MP4 ? Tks

Hi, anyone knows how to convert VOB files into MP4 ones ? Tkshttp://forums.macrumors.com/showthread.php?t=812985 The procedure is dated and I will assume that the DVD is not copy-protected since discussion of such things is verboten.Read other 3 answ