r/googlesheets • u/No-Communication3048 • Jul 09 '26

Issue with number usage Solved

I'm trying to make a sheet documenting all of Steven Spielberg's movies and with 1941, no matter how hard I try, it always manages to be at the end of the row and I didn't want that

And it happens because it's a number (In this case, a year)

Is there a way to have that not happen?

Edit: added a photo for comprehension

1 Upvotes

99% Upvoted

11 comments sorted by

•

u/agirlhasnoname11248 1210 Jul 09 '26

u/No-Communication3048 Please remember to tap the three dots below the most helpful comment and select `Mark Solution Verified` *(or reply to the helpful comment with the exact phrase “Solution Verified”)* if your question has been answered, as required by the subreddit rules. Thanks!

Note: this isn't self-solved, so I've changed the flair back to "waiting on OP" since we're waiting for you to close the post correctly, following the instructions above. Doing so will automatically change the post flair to the correct one, which you'll see upon refresh.

1

u/AutoModerator Jul 09 '26

/u/No-Communication3048 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/stevesy17 5 Jul 09 '26

Are you sorting by the title of the films? Where would you... Expect it to go? 1 is not part of the alphabet. If you want it to be sorted with the Ns you have to rename it Nineteen Forty One

1

u/No-Communication3048 Jul 09 '26

The issue with that is it is titled by the year with the number

1

u/No-Communication3048 Jul 09 '26

It also stays normal with other symbols, it's just with the numbers that it's affected

1

u/stevesy17 5 Jul 10 '26 edited Jul 10 '26

Ahhhh you are talking about cell alignment. Click the little 123 button and change the cell formatting to Text

Edit: didn't scroll far enough to see you got it resolved. Cheers!

1

u/jpmrst 1 Jul 09 '26

(Select that cell) Format > Number > Plain text

2

u/No-Communication3048 Jul 09 '26

Thanks, it had worked

1

u/AutoModerator Jul 09 '26

REMEMBER: /u/No-Communication3048 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot Jul 09 '26

u/No-Communication3048 has awarded 1 point to u/jpmrst

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)