DON'T LAUGH!!! The number 20.

Discuss the spreadsheet application
Post Reply
RKPanzer
Posts: 1
Joined: Mon Jun 05, 2017 10:52 am

DON'T LAUGH!!! The number 20.

Post by RKPanzer »

How in the hell do I enter the number 20 into any cell without calc turning it into a symbol?!
OpenOffice 4.1.3 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: DON'T LAUGH!!! The number 20.

Post by Villeroy »

2 0 Enter
Works for me
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: DON'T LAUGH!!! The number 20.

Post by RoryOF »

Select a cell with the symbol, choose /Format /Cells; on te Numbers tab, what format is selected in the Category column?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: DON'T LAUGH!!! The number 20.

Post by acknak »

Could this be a keyboard configuration issue (or even a hardware issue—stuck key)? I know some input methods allow entering numeric codes for symbols/characters from the keyboard.
AOO4/LO5 • Linux • Fedora 23
User avatar
keme
Volunteer
Posts: 3704
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: DON'T LAUGH!!! The number 20.

Post by keme »

Could also be a "rogue" autocorrect item. In that case, undo will revert to what you typed, before autocorrection.

See Tools - Autocorrect options.

The Norwegian function name for TODAY() is "IDAG()". No problem with that in Calc. MS Excel autocorrects to separate words, "I DAG()", because agglutination is wrong (though common) for that term. When I enter the formula, Excel tells me that I have made a mistake in the formula and asks whether to correct the function name (back to what I initially wrote).
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
User avatar
DolphyausDutchland
Posts: 10
Joined: Thu Jan 01, 2015 5:30 am

Re: DON'T LAUGH!!! The number 20.

Post by DolphyausDutchland »

Don't know, but is
'20
that?
Then you have the number treated as a text-string,positioned left in your cell.
Please give us a feed-back... Greetz Chris
OpenOffice.org (OOo) 3.0.0 on Windows 7; Notebook with XP and Apache OpenOffice (AOO) 4.1.3
Post Reply