Ask Your Question

Date input using symbol "/". [closed]

asked 2013-04-02 13:25:11 +0100

Aigars gravatar image

updated 2013-04-02 13:26:10 +0100

I set cell properties to date format DD.MM.YY then enter date 2/4/13, it's supposed to change from 2/4/13 to 02.04.13, but it doesn't. But when I inpud date - 2.4.13 it's changed to 02.04.13. Is it possible to make calc change date from 2/4/13 to 02.04.13?

P.S. This works in Open Office and I'm used to input date using numpad.

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 2015-10-27 23:46:51.492338

1 Answer

Sort by » oldest newest most voted

answered 2013-04-02 13:31:23 +0100

Aigars gravatar image
edit flag offensive delete link more



It looks like this is a feature, not a bug. :)) So not recognizing too many strings as date instead of text. To customize what is accepted as date, you can set with above settings.

froz gravatar imagefroz ( 2013-04-02 13:40:36 +0100 )edit

@froz yeah, I have to admit there have been times when I enter something and it's turned into date and I had to change cell properties to text. I edited the date acceptance patterns and now it works as I wanted it to :)

Aigars gravatar imageAigars ( 2013-04-02 13:43:54 +0100 )edit
manj_k gravatar imagemanj_k ( 2013-04-02 19:32:57 +0100 )edit

Question Tools

1 follower


Asked: 2013-04-02 13:25:11 +0100

Seen: 908 times

Last updated: Apr 02 '13