html to excel with php. Big numbers converts to exponential -

-

i'm exporting html table excel php. have problem column big numbers

example: 12345678901234567890

excel converts 1.23457e+19 in general format.

i want display full number - completely.

prepend single quote numbers have length > 10-12. have same problem few part numbers.

vba

bignumber = "'" & bignumber

or

php

$bignumber = "'" . $bignumber

my php rusty, might have escape quote.


Comments

Post a Comment

Popular posts from this blog

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

parcelable - Unmarshalling unknown type code exception while reading parcel values in Android 4.4+ -

-
i'm using parcelable interface , working fine till android 4.3 (jelly bean) when install same app on device running under android 4.4+ (kitkat) crashing while reading parcel. throwing below error : java.lang.runtimeexception: parcel android.os.parcel@42acce90: unmarshalling unknown type code 6881383 @ offset 1864 when try read : getintent().getextras().getstring("type").contains("some_type"); i have put extra in intent : intent ointent = new intent(getactivity().getapplicationcontext(), eventfragment.class); ointent.putextra("type", "some_type"); after long time , r&d, came know should not use arraylist inside arraylist , within parcelable object. causing issue. so end-up using serializable interface provided java , both concept same.
Read more