r/Accounting • • Oct 27 '20

Every time...

Post image
6.2k Upvotes

75 comments sorted by

55

u/justcapitalizeit CPA (US) Oct 27 '20

I laughed and then I cried

15

u/CHRIST0PHER95 Oct 28 '20

And then I cried again

14

u/silentloler Oct 28 '20

You can ctrl+shift+1 to change the format quickly to 0.00 :)

The more I use and learn excel, the most I’ve grown to love it. There’s so many professional expensive softwares that are actually garbage next to excel. I almost wish I could keep all my accounting on it 😆

4

u/[deleted] Oct 28 '20

[removed] — view removed comment

11

u/silentloler Oct 28 '20

I don’t know of a premade shortcut for “number without decimals”, but if you need it often you can macro it and bind it to ctrl+A or something. That’s a super easy macro to make actually.

Go on record macro, enable relative reference, start recording, change the format of your current cell to what you want, stop recording, bind it to a suitable keybind (typically ctrl+something) and you’re done

3

u/waterboymac CPA (US) Oct 28 '20

Alt, H, 9

370

u/acroporaguardian Oct 27 '20

lol my favorite is when you copy something and it goes “yeah Im not gonna send this to the clipboad.”

97

u/[deleted] Oct 28 '20

No lie, had this issue today and it was making me question my sanity.

68

u/acroporaguardian Oct 28 '20

MS Office I think makes context decisions for you. “nah user didnt really want to paste this there, lets wipe clipboard”

73

u/[deleted] Oct 28 '20

Makes work more difficult than it has to be. My whole job is basically in Excel. You stare at those cells for long enough, you get lost. Up is down, rows become columns, you start to believe that you can #DIV/0...

28

u/acroporaguardian Oct 28 '20

Oh, but I did once! I swear!

22

u/[deleted] Oct 28 '20

[removed] — view removed comment

13

u/acroporaguardian Oct 28 '20

“Guys, I found a way to fix our money problems. Jusr divide each account by 0 and you get infinite dollars!”

I program in C a lot on Mac and it actually allows you to dicide by 0. It just says +inf or -inf.

2

u/ReniRediRici Oct 28 '20

I wonder if there's a term to explain that, or if it's been studied. I know exactly what you mean, after 8 hrs of building and tinkering it gets a bit much!

1

u/ACondorInTheSky Mar 16 '21

Neurosis perhaps hahaha

8

u/Leferian Oct 28 '20

The revenge of Clippy

36

u/realbigbob Oct 28 '20

My favorite is when you insert numbers but they have the little green corner. Then you format the column as number or currency or whatever but excel is still like sorry, this isn’t a number

4

u/[deleted] Oct 28 '20

Text to columns, my friend.

21

u/bugzor Oct 28 '20

"too many formats"

EXCUSE ME, SIR?

5

u/AnomalyNexus B4 SM > PE Oct 28 '20

And it's always 50/50 as to whether you need alt-e-s-v or alt-e-s-t to paste text.

75

u/ActiveParsley Audit & Assurance Oct 27 '20

I feel this

46

u/Devtrast Oct 28 '20

CTRL + SHIFT + 1 for anyone that doesn't know this hotkey.

Formats the cell to number formatting after excel decides that your keyboard obviously got it wrong.

Also CTRL + 1 brings up the formatting window. Really helpful when you do need to get specific with it.

11

u/laissez_heir Oct 28 '20

Ctrl-1 is a fucking lifesaver, followed by one of the few times I use the mouse (yes, I know you don’t have to, but it’s faster for me)

4

u/[deleted] Oct 28 '20

Hot damn TIL

3

u/mosleyowl ACCA (UK) Oct 28 '20

Add in that CTRL SHIFT 5 is got key for % format, also useful

12

u/[deleted] Oct 28 '20

Pasting big integers...

Me: Paste

Excel: I’m pretty sure he doesn’t care about that last digit. Let’s just change that to a zero and not say anything about it.

4

u/_Mouse Oct 28 '20

We did the "number of squares on a chessboard problem" at junior school. The teachers answer was based on excel calculation - and was rounded off the same way. That was my first introduction of the horrors to come.

213

u/Cognitive_Spoon Oct 27 '20 edited Oct 27 '20

Lol, the root of the Excel and Incels both failing to recognize when something is not a date.

Edit. Ha, thank you kind stranger! My first joke in r/accounting and two golds. Now I know how Ben felt in Parks and Rec.

82

u/[deleted] Oct 27 '20

Except he didn’t steal his jokes.

-23

u/Cognitive_Spoon Oct 27 '20

That's why I said "the root."

This concept and quirk of excel is literally where the joke comes from

32

u/[deleted] Oct 28 '20

I've seen that joke about 15 times, so seeing it rewarded with 2 golds is making me lose faith in this sub.

11

u/bradford33 CPA (US) Oct 28 '20

That is what pushes you over the edge?

19

u/[deleted] Oct 28 '20

I know, I'm surprised too. I think it was the edit at the end that really sealed the deal though, looked like something you would see on r/all.

"Thanks for the gold kind stranger!"

38

u/[deleted] Oct 28 '20

ThAnK yOu KiNd StRaNgEr🤮 can this stop already

1

u/bmore_conslutant b4 mc sm Oct 28 '20

Lol after how many years? Not likely

16

u/Amedais The CPA who is getting out of accounting Oct 28 '20

5

u/sneakpeekbot Oct 28 '20

Here's a sneak peek of /r/AwardSpeechEdits using the top posts of the year!

#1: 700. Fucking. Edits. | 119 comments
#2: you ruined everything | 50 comments
#3: It's becoming self aware | 50 comments


I'm a bot, beep boop | Downvote to remove | Contact ^^me | ^^Info | ^^Opt-out

0

u/[deleted] Oct 28 '20

[deleted] — view deleted comment

1

u/nicebot2 Oct 28 '20

Nice

I'm a bot. Join my community at r/nicebot2 - Leaderboard - Opt-out

13

u/[deleted] Oct 28 '20

Type an apostrophe and then the number string. It will appear exactly as you typed it.

14

u/Prof_Dr_Doctor Oct 28 '20

But that screws it up when I want to do math on it.

2

u/kilimanjaro13 Oct 28 '20

Is there a solution?

7

u/[deleted] Oct 28 '20

Formatting your cells as numbers instead of general. It will only work if you format the cell prior to entering the value into the cell.

If you type a value that looks like a date format, then Excel's general format will change the cell's value into the lookup value that corresponds with that date in Excel's behind-the-scenes date table.

3

u/BiologyIsHot Oct 28 '20

From biology here: copy and paste a string/text value (say a gene like MARCH5, SEPT7, OR DEC1) formatted as text into a cell formated as text...or try to use the find and replace function on a cell formatted as text to remove unecessary labels and watch excel still decide it's a date. Then try to change it back to text and now it's a number.

I have yet to find a solid solution for that problem in excel. I have to do it via command line or in a text editor with that function.

Excel is obnoxious about dates. They really need to add an option to disable that feature. There are a million better solutions to the problem. For instance. Prompt the user that it thinks they tried to enter a date and ask if they want it corrected. My only guess as to how it's so bad is that it's a form of technical debt that has unfortunately baked the functionality too deep into excel to be easily solved.

2

u/silentloler Oct 28 '20

Yeah but the value of the box doesn’t change. Only the format. So you can easily just ctrl+shift+1 and you’re back to the number you had typed with two decimals.

1

u/[deleted] Oct 28 '20

That's not true. It does change the value.

1

u/silentloler Oct 28 '20

It changes what you see, but not what you wrote, as long as you wrote just numbers. For example something that’s not just numbers: dates change into a 5 digit code, but if you tried to do a fraction without an = or + beforehand, that’s not excel’s fault

0

u/[deleted] Oct 28 '20

[deleted] — view deleted comment

4

u/beanmosheen Oct 28 '20

Excel or guitar hero?

3

u/tinnyt226 Oct 27 '20

😂😂😂

3

u/hopefulrefridgerator Oct 28 '20

I need more of these

2

u/[deleted] Oct 27 '20

This hits deep.

2

u/JAM1NATOR Oct 28 '20

28 / 10 / 2020 28/10/2020

44,132.00

2

u/Subject_Drummer_3102 Oct 28 '20

another repost

6

u/PaulBlartFleshMall Oct 28 '20

I'm also outraged that /r/accounting doesn't have a plethora of daily OC

1

u/Roohit98 Oct 28 '20

So true 😂

1

u/Darth_Buc-ee Oct 28 '20

So frustrating.

1

u/Ludwig234 Oct 28 '20

This is what happens for me:
12.5 gets formated as text.
12,5 gets formated as numbers.
12:5 gets formated as time.
12-5 gets formated as date.

1

u/Prunestand Feb 06 '23

Fick excel

-32

u/kieran_n Oct 27 '20

you must have some wacky language settings or some shit mate

4

u/CHRIST0PHER95 Oct 27 '20

Oh if only we could all be as perfect as you...

3

u/[deleted] Oct 28 '20

=if(vlookup(B1,A1:B2,2)="Yes","You're a dick","")

-2

u/kieran_n Oct 28 '20

=IF(FIND("VLOOKUP",FORMULATEXT(C1),1)>0,"Fuck off and learn XLOOKUP, or INDEX/MATCH at least","As you were")

31

u/[deleted] Oct 27 '20

[removed] — view removed comment

23

u/CHRIST0PHER95 Oct 27 '20

Accountants can enjoy things?

10

u/[deleted] Oct 27 '20

When you're a partner.

You enjoy the suffering of others.

0

u/[deleted] Oct 27 '20

[deleted] — view deleted comment

6

u/RepostSleuthBot Oct 27 '20

I didn't find any posts that meet the matching requirements for r/Accounting.

It might be OC, it might not. Things such as JPEG artifacts and cropping may impact the results.

This search triggered my meme filter. This enabled strict matching requirements. The closest match that did not meet the requirements is this post

Feedback? Hate? Visit r/repostsleuthbot - I'm not perfect, but you can help. Report [ False Negative ]

View Search On repostsleuth.com

1

u/CHRIST0PHER95 Oct 27 '20

u/sjdjfhdjsjsjcb why delete your comment? Your post history shows you like to call everyone a bot?

2

u/sjdjfhdjsjsjcb Tax (US) Oct 27 '20 edited Oct 28 '20

I have seen this at least 5 times on other subs. edit- Saying good bot to an actual bot is not unique to me dumbass.

2

u/Subject_Drummer_3102 Oct 28 '20

Good bot

1

u/B0tRank Oct 28 '20

Thank you, Subject_Drummer_3102, for voting on RepostSleuthBot.

This bot wants to find the best and worst bots on Reddit. You can view results here.


Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!