Open Office Question


  1. Posts : 3
    Windows 10
       #1

    Open Office Question


    I just joined, so I hope I'm posting this in the correct place. I bought a Dell laptop several months ago and my son put Open Office on it for me to use. I am familiar with doing spreadsheets from when I used MS Excel, but now I can't seem to locate on Open Office how to do something that I'd like to do. How do I change an entire spreadsheet so that I don't have to type decimals? For instance, if I want the number 357.75 to show up in a cell, I would just have to type 35775. Then when I'd hit Enter, the number would automatically have a decimal inserted in front of the last two numbers. It would make for a little more convenience not having to keep typing decimals in numbers. Thanks in advance for any help you can give me.
      My Computer


  2. Posts : 16,783
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #2

    See https://www.openoffice.org/ for guidance on using OpenOffice.

    Denis
    Last edited by Try3; 21 Apr 2019 at 12:00.
      My Computer


  3. Posts : 2,716
    Windows 10
       #3

    Just a matter of Cell Format Code/Formula. Same in OpenOffice Calc as Excel.
    Format code something like this, though this has rounding:
    ##.##,
      My Computer


  4. Posts : 3
    Windows 10
    Thread Starter
       #4

    I don't know if the openoffice.org website has anything else in addition to what I looked at using F1 when I was in a Open Office spreadsheet. I looked and looked and couldn't locate the instructions how to do the automatic decimal.
    When I had used MS Excel, I clicked on Tools, then Optionis, then after that I'm not sure if I had to select a tab and then go down below in the box and select whatever it was that made the decimal point show up. Well, if nobody here knows specifically what to do and if I'm not able to find the instructions somewhere, either by looking in the spreadsheet like I did today or by checking out the Open Office website, I might just have to get used to continuing to type in all of the decimals. I can't imagine that the program wouldn't have this option. There seems to be so many things you can do with spreadsheets that it's mind-boggling and I'd never learn it all if I lived to be 100.
      My Computer


  5. Posts : 16,783
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #5

    But Helmut has posted the solution for you.

    Just find out how to do the OpenOffice equivalent of Excel's right-click, Format cells, Custom and type in
    Code:
    ##.##,
    [note that the trailing , is part of what you need to enter].

    Denis
      My Computer


  6. Posts : 3
    Windows 10
    Thread Starter
       #6

    Thank you all for your replies.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 14:36.
Find Us




Windows 10 Forums