Convert string/numeric date in Excel to a date formatted object using only formulas -

-

folks,

i have string date can convert numeric using: =datevalue("1/2/2011") results in 39084

i'm trying use formulas convert either string or numeric date date formatted object. using ui formatting not option.

use text()

example:

=text(datevalue("1/2/2011"), "yyyy/mm/dd")

Comments

Post a Comment

Popular posts from this blog

forms - Secure PHP File Upload Script -

-
i have asked question twice think, first time have gotten close this. planning on allowing users upload , download files (.pdf, .doc, .exl, .ppt, .png, .jpg, .gif). will these tips suffice: http://blogs.sans.org/appsecstreetfighter/2009/12/28/8-basic-rules-to-implement-secure-file-uploads/ also, there script can utilize, new php. a late response, think script should based on this: http://blog.insicdesigns.com/2009/01/secure-file-upload-in-php-web-applications/ it covers aspects of security , explains valid points. hope helps. edit: above link dead, here cached version of article .
Read more

PHP: Exploding array elements -

-
i have 2d array have exploded string. once has exploded output: ---> 0 - 16~4~0.0~~~~false~~~~ ---> 1 - 1000.0~21.75~l~1~2.0~2.0~l~2~ ---> 2 - ---> 0 - 2~5~951.3~6.4~~~false~~~~ ---> 1 - 1000.0~11.77~l~1~ ---> 2 - ---> 0 - 3~6~1269.02~5.1~~~false~~~~ ---> 1 - 5.0~213.66~l~1~4.9~2.56~l~2~4.6~19.5~l~3~ ---> 2 - 5.1~53.44~b~1~5.4~8.48~b~2~5.5~15.53~b~3~ i want make each position in array takes first value before ~. unsure how this. code have far: $test = explode(":", $string); foreach($test &$value) $value = explode('|', $value); just in case need original string input: 1~1~828.32~12.5~~~false~~~~|1000.0~41.73~l~1~2.0~2.0~l~2~|:4~2~4.16~12.5~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:9~3~0.16~24.0~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:16~4~0.0~~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:2~5~951.3~6.4~~~false~~~~|1000.0~11.77~l~1~|:3~6~1269.02~5.1~~~false~~~~|5.0~213.66~l~1~4.9~2.56~l~2~4.6~19.5~l~3~|5.1~53.44~...
Read more

java - How do I override the spring framework version in Spring Batch? -

-
i'm starting new project spring batch 2.1.6.release , use maven depemdency management. by default, imports spring framework 2.5.6, i'd use 3.0.5.release instead. this post says it's compatible, don't know how declare in maven pom file. i tried putting dependencies spring-core, spring-beans , spring-context versions 3.0.5.release, adds libraries project without removing 2.5.6 version. i had @ spring-batch-parent pom file, , there profile called "spring3" uses spring version want. how activate profile in project's pom file ? thanks in advance, philippe you can exclude transient dependency on spring framework v2.5.6 of spring batch using dependency exclusions element of spring-batch dependency in maven. like... <dependency> <groupid>org.springframework.batch</groupid> <artifactid>spring-batch-core</artifactid> <version>2.1.6.release</version> <exclusions> <exclusion...
Read more