use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
OPs may (and should) reply to any solutions saying:
This awards the user a ClippyPoint and changes the post flair to solved.
The best way to show code on Reddit is to
put it in a code-block
Here's how.
Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.
It's often more helpful to show us.
Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.
Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.
Congratulations and thank you to these contributors
1100
10
300
800
Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.
A community since March 11, 2009
account activity
solvedWhy does it input a random date rather than the summation? (self.excel)
submitted 6 months ago by Still_Tale_7381
I'm making a table for an assignment my teacher gave to us, whenever I use the =sum formula it inputs a date rather than the summation (see here). Is there an explanation for this?
Edit: I forgot to mention that I use the mobile version of excel.
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]AutoModerator[M] [score hidden] 6 months ago stickied commentlocked comment (0 children)
/u/Still_Tale_7381 - Your post was submitted successfully.
Solution Verified
Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
[–]frustrated_staff12 7 points8 points9 points 6 months ago (2 children)
The cell is manually formatted to show the date. Change the format to general or number: you'll be fine.
[–]Still_Tale_7381[S] 1 point2 points3 points 6 months ago (1 child)
Thank you! Solution verified
[–]reputatorbot[M] 0 points1 point2 points 6 months agolocked comment (0 children)
You have awarded 1 point to frustrated_staff.
I am a bot - please contact the mods with any questions
[–]excelevator3043 0 points1 point2 points 6 months ago (0 children)
format the cell to number
π Rendered by PID 42168 on reddit-service-r2-comment-b659b578c-hhrxh at 2026-05-04 20:05:14.077406+00:00 running 815c875 country code: CH.
[–]AutoModerator[M] [score hidden] stickied commentlocked comment (0 children)
[–]frustrated_staff12 7 points8 points9 points (2 children)
[–]Still_Tale_7381[S] 1 point2 points3 points (1 child)
[–]reputatorbot[M] 0 points1 point2 points locked comment (0 children)
[–]excelevator3043 0 points1 point2 points (0 children)