excel - Convert range formatted as date to text -

-

i have range of cells in date format, formatted dd.mm.yyyy, this:

05.10.1993 05.10.1993 05.10.1993 05.10.1993

and want convert range of cells text format, using vba, without iterating each cell in range (as slow large range).

i used code:

set rsel = selection  adate = rsel.value rsel.numberformat = "@" rsel.value = adate

so assign selected range intermediate array, convert range text format , assign array selected range.

result text:

5/10/1993 5/10/1993 5/10/1993 5/10/1993

and wonder did format conversion took place, if debug.print example adate(1,1) expected 05.10.1993 value? or how can instruct format in simple snippet posted expected text result?

in code, instead of adate=rsel.value, try this:

adate = application.text(rsel.value2,rsel.numberformatlocal)

note

the following range properties relevant example:

.value returns variant (number/date/string/boolean/error) dates in vba date format.

.value2 returns variant (number/string/boolean/error) dates converted serial numbers.

.text returns string containing formatted value, applies individual cells only.

.numberformat returns regional formats in format (eg entering 1/2/3 in cell gives m/d/yyyy)

.numberformatlocal returns regional formats in local format (eg in european locale d/m/yy)


Comments

Post a Comment

Popular posts from this blog

mod rewrite - Using "?" when rewriting the URL -

-
i have been researching weeks looking how rewritting file/directory complementary "?" or "question mark" what need: http://mydomain.com/demo01.php to like: http://mydomain.com/?theme=jerus theme > simple directory need use websites products(in case themes) jerus > name of theme extra info: i plan on rewritting every url individually refrain wildcard varibles.** wouldn't easy instead of doing url rewriting put php in directory called theme , name index.php? http://mydomain.com/theme/?t=jerus but if you're re-writing urls make rule acutally make route this: http://mydomain.com/theme/jerus/ which waaaay prettier see question: using clean urls in restful api
Read more

.htaccess: Transfer name to index.php if not directory public -

-
i have piece of code: options followsymlinks <ifmodule mod_rewrite.c> rewriteengine on rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewriterule ^(.*)$ index.php?url=$1 [l] </ifmodule> <ifmodule !mod_rewrite.c> errordocument 404 /index.php </ifmodule> i don't know how allow directory name "public" inside folder .htaccess, other names dir should transfered index.php. how that? add rewritecond exclude public directory rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewritecond %{request_uri} ^/public(/.*)?$ rewriterule ^(.*)$ index.php?url=$1 [l] now, redirection work /public directories only. if want url have rest of path that's below public url=subfolder/page.php /public/subfolder/page.php use rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewrit...
Read more

Admob integration with pygame in android -

-
hello curious know solution integrating admob app written in pygame subset android. have tried below things did' t work me :( still nothing working me may there no way :( try 1: followed google https://developers.google.com/mobile-ads-sdk/docs/admob/fundamentals#android solution has no code change build.xml modification didt works me :( try 2: tried below solutio also. http://www.michenux.net/android-admob-tutorial-461.html did't work me :( try 3: tried hack pythonactivity.java. getting below related errors. have googleadmobadssdk-6.4.1.jar in \pgs4a-0.9.4\libs path still below kind of error. below code: protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //vrbilgi setcontentview(r_layout_main); // setcontentview(r.layout.main); // create adview // adview = new adview(this, adsize.banner, my_ad_unit_id); adview = new adview(this, adsize.banner,"a15...
Read more