[Solved] Remove % format in single cells

Discuss the spreadsheet application

[Solved] Remove % format in single cells

Postby crabmann » Sat Dec 14, 2019 12:05 am

I formatted a row calculation to read in %. Now I want to delete that calculation from selected cells and replace it with just a figure. Tried "special paste" instructions from community support but couldn't make it work.
Last edited by RoryOF on Sat Dec 14, 2019 10:59 am, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Open Office 3.4.1 on Windows 8
crabmann
 
Posts: 33
Joined: Thu Dec 27, 2012 2:34 am

Re: Remove % format in single cells

Postby RusselB » Sat Dec 14, 2019 12:21 am

Highlight the cell(s) that you want to replace. If more than one, I recommend ensuring that they are contiguous (ie: no breaks).
Press Ctrl+C (copy)
Place the cursor on the first cell where you want to number pasted.
Press Ctrl+Shift+V (Paste Special)
Ensure that Formulas are unchecked
Decide which, if any others, you want to check/uncheck.
Click OK
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6211
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Remove % format in single cells

Postby crabmann » Sat Dec 14, 2019 2:27 am

Thanks. Did that,formulas unchecked, still can't get rid of the % format in those cells. It originally came from row format. Can I insert a pdf file to show you what I have?
Open Office 3.4.1 on Windows 8
crabmann
 
Posts: 33
Joined: Thu Dec 27, 2012 2:34 am

Re: Remove % format in single cells

Postby RusselB » Sat Dec 14, 2019 3:41 am

It'd be better for you to upload a copy of your actual spreadsheet.
There's information in this tutorial about anonymizing and attaching a document to the forum.
However, before you go that step, you could also try ensuring that Formats is also unchecked in the Paste Special or use Ctrl+M for the highlighted cell(s)
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6211
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Remove % format in single cells

Postby keme » Sat Dec 14, 2019 8:54 am

To override a row format for some cells, just apply whatever formatting you want to those cells.

If you want the default, "dynamic" format (which will recognize some data types on input, and adjust display accordingly), specify "Default" as the format code.
User avatar
keme
Volunteer
 
Posts: 3390
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Remove % format in single cells - SOLVED

Postby crabmann » Sat Dec 14, 2019 9:54 am

Control+M worked. Thanks to all
Open Office 3.4.1 on Windows 8
crabmann
 
Posts: 33
Joined: Thu Dec 27, 2012 2:34 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests