Autoinsert decimal 2 decimal places from end?

Discuss the spreadsheet application

Autoinsert decimal 2 decimal places from end?

Postby Boggle » Fri Dec 27, 2019 5:28 pm

For example, when I input 1234 I want it to return 12.34 instead of 1234.00

I'm using it on a expense sheet so when I am rapidly entering expenses, not having to hit the Decimal key saves time.

There was a similar question here but it was years ago. This was something I was able to do in excel as described here: ... b3be0377c4 but I can't seem to find the option in OpenOffice.
Open office 3.1 on Ubuntu 18.04
Not really though. Forced to put something to meet this stupid requirement
Posts: 1
Joined: Fri Dec 27, 2019 5:24 pm

Re: Autoinsert decimal 2 decimal places from end?

Postby RoryOF » Fri Dec 27, 2019 6:20 pm

Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 31409
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Autoinsert decimal 2 decimal places from end?

Postby MrProgrammer » Fri Dec 27, 2019 6:35 pm

Hi, and welcome to the forum.

Boggle wrote:Autoinsert decimal 2 decimal places from end?
This feature is not available in Calc.

You could enter all the data without the decimal point, then convert all numbers at once by dividing them by 100 (Edit → Paste Special → Operations:Divide → OK). Read about Paste Special in Help → Index or in User Guides (PDF) or searching for topics about it in the Calc Forum.

RoryOF wrote:Also asked at …
Boggle, it is polite to provide links when posting the same question to multiple forums. Please do that in the future.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
Posts: 3960
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests