Ask Your Question
0

= 0.04 / 12 is a date?

asked 2015-08-01 01:22:02 +0100

Buttons840 gravatar image

I have a cell which I would like to contain a numeric value. The value I want is 4% divided by 12.

I have entered this formula as "= 0.04 / 12" which Calc interprets to be a date?

Is there any way to get the numeric value I want without using multiple cells?

edit retag flag offensive close merge delete

Comments

I'm enter =4%/12 and it returns what I expect → 0.0033333333

karolus gravatar imagekarolus ( 2015-08-01 08:51:45 +0100 )edit

Which locale are you working in? See menu Help->About or Tools->Options->LanguageSettings->Languages What are you date acceptance patterns? See Tools->Options->LanguageSettings->Languages

erAck gravatar imageerAck ( 2015-08-11 18:20:41 +0100 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2015-08-01 08:40:52 +0100

pierre-yves samyn gravatar image

Hi

This may depend on the dates recognition parameters according to the "locale" : Tools Options Language Settings Languages Date acceptance patterns.

Regards

edit flag offensive delete link more
0

answered 2015-08-01 17:48:19 +0100

horst gravatar image

updated 2015-08-01 17:54:45 +0100

With en-US locale i get text if I enter "0.04/12" (no quotes) which I would expect. This is not like @Alex Kemp.

With = it calculates the formula.

If I format the cell as Date and enter "=0.04/12" (no quotes) I get "12/30/99" not "4/12/2015" which is also expected.

From my point I have no idea what happened and can not replicate any thing.

I'm using LO 4.4.4 on Win7, you did not mention your LO version.

edit flag offensive delete link more
0

answered 2015-08-01 02:08:55 +0100

Alex Kemp gravatar image

It is a question of formatting.

I entered "0.04/12" (no quotes) (notice also no '=') in a cell of a brand-new spreadsheet & got the same ('04/12/2015') (if I enter "=0.04/12" (no quotes) I get '0.003333...').

Next, I formatted as '%':-
(menu):Format|Number Format|Percent (Ctrl+Shift+5)

...now I enter "=4/12" (no quotes) & it shows '33.33%'.

If this helps then please tick the answer (✔).

edit flag offensive delete link more

Comments

Which locale are you working in? See menu Help->About or Tools->Options->LanguageSettings->Languages What are you date acceptance patterns? See Tools->Options->LanguageSettings->Languages

erAck gravatar imageerAck ( 2015-08-11 18:21:07 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-08-01 01:22:02 +0100

Seen: 97 times

Last updated: Aug 01 '15