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 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
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
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