/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
Decimal needs to be different in the first 4 rows 0 Recommended Answers 11 Replies 1 Upvote
1 Recommended Answer
$0 Recommended Answers
I need to  format the first 4 rows in a column with 4 decimal and the rest with 2 decimal. If I sort  the theet the first 4 rows still need to be 4 decimal.

How can I do this ?
All Replies (11)
Hi Detlef Deutsch,
 
We would like to help you with this but because there are so many variables that can affect your results, we need to see a sample of your problem.  Would you please take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”?  Thanks!
 
Adam
Platinum PE volunteer (not a Google employee)
 
When you've received a response that answers your question, please observe these forum courtesies:
 • Leave your demo sheet shared as View Only as part of this solution's archive,
 • Click Recommend on the post that best addressed your question, and
 • Post again soon!
marked this as an answer
-
https://drive.google.com/file/d/10VSPlbbRSlcy4hepWPfuYDZvAauPGD56/view?usp=sharing

the task can be seen in the sheet with the number 4.  The first 4 rows need to stay with 2 decimal , even when it the data get sorted
marked this as an answer
Your sample file is in Excel format.  Are you wanting your file in that format?
 
Adam
marked this as an answer
Would you please open the original file and then using the Share button, select the permissions of "Anyone with link" and "Edit".  You will then receive a link that you can share here.  This link has an explanation and examples of how to do this -  Best Practices When Asking a Question.
 
Adam
marked this as an answer
We're almost there!  The file is now in View Only mode which does not allow the file to be edited and it hides some formula and other information.  Please change the settings to "Anyone with link can edit".  Thanks!
 
Adam
marked this as an answer
-
https://docs.google.com/spreadsheets/d/1gtrt9qCI0HzlUKDOeyiGyx2ZJ6qX57HFxwuaor9oyvQ/edit?usp=sharing

Thank you for being so patience.Please take this link. I created a new sheet on my other gmail account..
Is it possible to look at question 2 also? I stuck  with how to move the duplicate with the lowest score.
marked this as an answer
OK but this file is also in View Only mode.  In order for a PE to more easily help you, the file needs to be in "Anyone with link can edit" mode.
 
Adam
marked this as an answer
-
so I had to change it to commenter i gues. Did it now
marked this as an answer
There should be an "edit" option.  That's what it needs to be set to.
 
marked this as an answer
-
I changed it now to editor.. I do not have more options
marked this as an answer
That worked.  Thank you.  I have entered a couple of sheets that will allow you to better explain what you need to occur.  If you go to the CHAT sheet now, we can discuss this more easily.
 
Adam
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/docs/profile/0?hl=en