Ask Your Question

How can this be changed? [closed]

asked 2014-09-27 21:10:30 +0100

Martin1 gravatar image

If I put in a cell, which is formatted with standard number, a number input that is separated by an underscore, is there after giving a carriage return, a date of created. How can this be changed? Martin

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 11:49:55.652585

1 Answer

Sort by » oldest newest most voted

answered 2014-09-27 21:58:38 +0100

m.a.riosv gravatar image

Except you have set up in: Menu/Tools/Options/Language settings - Date acceptance patterns one with "_" underscore as separator, or is default separator for the language in locale settings, I don't know how it can be converter in a date.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-27 21:10:30 +0100

Seen: 31 times

Last updated: Sep 27 '14