[Solved] Numbers showing as percentages no matter what

Discuss the spreadsheet application

[Solved] Numbers showing as percentages no matter what

Postby NickBusey » Tue Nov 26, 2019 7:13 pm

I have a spreadsheet I've been using for years with no problem. Recently opened it up in OpenOffice, not sure if it was a new version of OpenOffice or what, but all the numbers in a certain group of cells always displays as a percentage.

I have deleted the cell contents, typed in '5' and it shows as '500.00%'.

Clicking the 'number format' buttons changes what displays in the formula line above the actual sheet, but in the sheet itself, it still shows as '500.00%' no matter what I click.

Any ideas?
Last edited by NickBusey on Tue Dec 03, 2019 3:01 am, edited 2 times in total.
OpenOffice 4.1.7 on MacOS 10.11.6
NickBusey
 
Posts: 2
Joined: Tue Nov 26, 2019 7:07 pm

Re: Numbers showing as percentages no matter what

Postby Hagar Delest » Tue Nov 26, 2019 8:17 pm

Hi and welcome to the forum!

Ctrl+M?
To reset the formatting.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28655
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Numbers showing as percentages no matter what

Postby NickBusey » Tue Nov 26, 2019 8:29 pm

Gah, that worked, but why? Why would it not let me change it otherwise?

Thanks though!
OpenOffice 4.1.7 on MacOS 10.11.6
NickBusey
 
Posts: 2
Joined: Tue Nov 26, 2019 7:07 pm

Re: [Solved-kinda] Numbers showing as percentages no matter

Postby Hagar Delest » Tue Nov 26, 2019 10:31 pm

There may have been a direct formatting applied one way or another on the cell.
Ctrl+M removes all such formatting.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28655
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests