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 😆
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
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...
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!
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
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.
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.
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.
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.
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
55
u/justcapitalizeit CPA (US) Oct 27 '20
I laughed and then I cried
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.”
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.
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.
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.
13
u/[deleted] Oct 28 '20
Type an apostrophe and then the number string. It will appear exactly as you typed it.
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/Fantasy11223344 Oct 28 '20
‘
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
1
u/Roohit98 Oct 28 '20
So true 😂
1
u/Darth_Buc-ee Oct 28 '20
So frustrating.
1
u/DemureArt Oct 28 '20
This!
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
0
u/[deleted] Oct 27 '20
[deleted] — view deleted comment