Hello,
Here are my thoughts written after the sign in response to Brian Barker's
ideas:
Spreadsheets generally used for calculation, so preventing it would usually be
considered a
drawback, not an advantage. You could put text
values into word processor tables instead. But chacun à son
Hello and happy new year!
At last, I knew how my colleagues strongly believed and what they wanted to
achieve.
They wanted a date format which works across all known free, paid, old and new
versions of spreadsheet program, e.g. LibreOffice Calc.
They decided to use .MM.DD. and MM.DD., e.g.
At 03:59 01/01/2015 +, Conly Honly Donly wrote:
At last, I knew how my colleagues strongly
believed and what they wanted to achieve. They
wanted a date format which works across all
known free, paid, old and new versions of
spreadsheet program, e.g. LibreOffice Calc. They
decided to use
Hi :)
Sounds like a good fail-safe, so that users are not bound by rigid
restrictions but the displayed figures are always consistently correct.
I suspect that you can even enter much shorter numbers for dates within the
year, such as;
12.31
getting corrected to;
2014.12.31
I'm not sure if you
Hello all,
Thanks for following up.
A quick recap: I was looking for the .MM.DD format. The user inputs it as
it looks, e.g. 2015.01.01. (LibreOffice Calc should recognise it as a date.)
Here:
Tools - Options - Language Settings - Languages - Date acceptance patterns
I don't know how
At 02:29 28/12/2014 +, Conly Honly Donly wrote:
A quick recap: I was looking for the .MM.DD format. The user
inputs it as it looks, e.g. 2015.01.01. (LibreOffice Calc should
recognise it as a date.)
Here:
Tools - Options - Language Settings - Languages - Date acceptance patterns
I
Hello all,
In a spreadsheet, I need the dot separated date in .MM.DD format, e.g.
2015.01.012015.12.11
Should I file a bug report to add this feature? Is it currently not available?
Please advise. Thanks.
C. H. D.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
--
To unsubscribe e-mail to:
I think it is already available.
You have to change the cell format (date type) in .MM.DD, nothing
more
Federico Quadri
C. H. D. webofht-libreoffice...@yahoo.com.hk ha scritto:
Hello all,
In a spreadsheet, I need the dot separated date in .MM.DD format,
e.g.
On Fri, 19 Dec 2014 14:47:02 + (UTC)
C. H. D. webofht-libreoffice...@yahoo.com.hk wrote:
Hello C.,
In a spreadsheet, I need the dot separated date in .MM.DD format,
e.g. 2015.01.012015.12.11
Go to Format Menu, Cells... then select Numbers tab - Time. Enter time
in the format you
At 14:47 19/12/2014 +, Conly Honly Donly wrote:
In a spreadsheet, I need the dot separated date in .MM.DD
format, e.g. 2015.01.012015.12.11
In the Format Cells dialogue, you can create your own User-defined
formats. Just enter your .MM.DD in the Format code box there.
Some
Hello all,
When I enter 2015.01.01, it is recognized not as a date. How do I make it one
step only? I enter it and it is detected as a date.
01-01-2015 is recognized as a date. Then I need to format this. Two steps are
required.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
--
To unsubscribe e-mail to:
I tried this, which seem to work: specifying the cell format with a custom
format .MM.DD. When I input a date in this form, it is kept this way,
and is recognized as a date (possible to use it in formula).
Is that not enough? Maybe I misunderstood the question.
--
Cley Faye
Hi all:
I think you need to use this format: /MM/DD
Regards,
Jorge Rodríguez
El vie, 19-12-2014 a las 14:47 +, C. H. D. escribió:
Hello all,
In a spreadsheet, I need the dot separated date in .MM.DD format, e.g.
2015.01.012015.12.11
Should I file a bug report to add
On 19 December 2014 at 08:47, C. H. D.
webofht-libreoffice...@yahoo.com.hk wrote:
In a spreadsheet, I need the dot separated date in .MM.DD format, e.g.
2015.01.012015.12.11
I suspect you would have more success using the ISO format of
-MM-DD instead of a non-standard format.
--
T.
Hi :)
If the formatting is set to display the date in the way that you want then
when you type in;
19/12
then it should display as
19.12.2014
(or whatever your formatting is for dates).
So if you have a whole column, or row of dates then it's not really a 2
step process, more like (n+1)/n steps
At 15:27 19/12/2014 +, Cony Honly Donly wrote:
When I enter 2015.01.01, it is recognized not as a date. How do I
make it one step only?
Aha! This is a different question: you need Calc to recognise your
entered text as a date, to convert the text string to the internal
number
16 matches
Mail list logo