[Solved] Cells formatted as currency display as percentage

Discuss the spreadsheet application

[Solved] Cells formatted as currency display as percentage

Postby crusader » Sat Feb 08, 2020 7:45 am

Attached is a spreadsheet I created to demonstrate my problem. I have formatted column C to provide values in the form of (US) dollars; however, I get values as percentages.

As part of addressing this issue, I made changes to the spreadsheet by going to Tools -> Customize and (unknowingly) making changes that included making the delete key dysfunctional. I was able to correct the delete key problem by researching this forum; unfortunately, I am unable to find the answer to my formatting problem mentioned in the first sentence. I uninstalled and reinstalled LibreOffice 6.4.0.3 in the hope of correcting the problem, but the problem persists.

Ideally, I am seeking to reset the whole "Tools -> Customize" set back to default (to get rid of all changes I unknowingly made), but cannot figure out how to do it.

All assistance will be greatly appreciated.
Attachments
Example.ods
(16.61 KiB) Downloaded 19 times
Last edited by MrProgrammer on Wed Feb 12, 2020 8:05 pm, edited 2 times in total.
Reason: Changed subject, was: Formatting Issues
LO 7.x on Windows 10
A candle loses nothing by lighting another candle.
crusader
Volunteer
 
Posts: 491
Joined: Sun Jan 20, 2008 5:06 am

Re: Formatting Issues

Postby erbsenzahl » Sat Feb 08, 2020 8:07 am

I selected the percent values and hit CTRL+M - the Dollar symbol showed. - Cheers
OpenOffice 4.1.7 on LinuxMint 19 or 20 Mate, rarely W7-64 pro and W10-64 pro; LibreOffice current versions 6 or 7
(author is no native speaker)
erbsenzahl
Volunteer
 
Posts: 158
Joined: Tue Apr 18, 2017 8:23 am
Location: Germany

Re: Formatting Issues

Postby Zizi64 » Sat Feb 08, 2020 9:20 am

My tip:
Use the Cell Styles instead of the manual (direct) formatting method.

The Styles are the most valuable feature of the Apache OpenOffice and the LibreOffice.
It is an excellent tool for efficient working.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9533
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatting Issues

Postby robleyd » Sat Feb 08, 2020 9:50 am

crusader wrote:I am seeking to reset the whole "Tools -> Customize" set back to default (to get rid of all changes I unknowingly made), but cannot figure out how to do it.


Go to Tools | Customise and select what you want to reset, e.g. Toolbars, Menus etc. and use the Reset button at the bottom right of the dialog box.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3456
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Formatting Issues

Postby crusader » Sat Feb 08, 2020 3:59 pm

Thank you for the supportive responses!

Erbsenzahl, your handy trick did the job.

Zizi64, in the decades of working with spreadsheets, I have yet to explore Cell Styles: I will do so now and see if it has the same charm for me. Thank you for the suggestion.

Robleyd, thank you for addressing the reset issue, (the other being why didn't Calc respond to my formatting). I tried resetting my customizations before posting my concern; however, I didn't see any difference - which may mean I didn't do as much "damage" as I thought.

I will mark the issue as resolved.
LO 7.x on Windows 10
A candle loses nothing by lighting another candle.
crusader
Volunteer
 
Posts: 491
Joined: Sun Jan 20, 2008 5:06 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 11 guests