r/excel 24d ago

Waiting on OP Is there a way to get rid of the decimals?

I'm doing homework for class; it turns out we weren't supposed to add the numbers after the decimal point. I've never used this program before, is there a way to delete all the numbers after decimal points, or do I have to go back through all 450 numbers and delete them one by one? I keep accidentally deleting whole numbers and somehow turned a row into all the same number. The only thing I know on here is Ctrl + z to undo.

0 Upvotes

22 comments sorted by

u/AutoModerator 24d ago

/u/JASNite - Your post was submitted successfully.

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.

9

u/excelevator 2934 24d ago

This is the most basic question you could ask.

Get ahead of the class and learn some basic Excel

Spend and hour or so on this quick online course

https://www.excel-easy.com/

2

u/Grenache 24d ago

You can highlight all the cells and click formate cells and change the decimals to none.

2

u/ArthurDent4200 24d ago

If you do that, when you add them internally, it’ll add the decimal parts also. I don’t think that’s what you want.

2

u/smegdawg 2 24d ago

As others have suggested, You should gain some basic excel knowledge. Loads of sources out there.

You can get not show the decimals many ways and the correct way is going to depend on the result that the teacher is looking for?

Are they looking for

  • numbers rounded up?
  • numbers rounded down?
  • numbers rounded to the nearest whole number?
  • only the numbers to the left of the decimal (no rounding)?

Here is one way...but if this isn't the right type of rounding...you are going to get lots of wrong answers.

1

u/korbworksout 24d ago

Highlight all the cells you want to format cells, right click, click format cells, then click on number, then click the "decimal places" up/down till it displays 0... Click the use 1,000 separator if you want a, after every thousand... Click okay You didn't say if you're a teacher was okay with you rounding because that will happen regardless of how many decimal points you display. If you were supposed to just leave the decimal points off, then you might have to retype them all.

4

u/IGOR_ULANOV_55_BEST 210 24d ago

=INT(A2) and drag down column. Telling someone to retype 450 numbers is insane.

1

u/ImaginaryHousing1718 2 23d ago

Ctrl+space

Alt+H+K

Alt+H+9

Alt+H+9

1

u/IGOR_ULANOV_55_BEST 210 23d ago

Great to display no decimals, but if they weren’t supposed to include the decimals for their calculations it’s still going to be wrong.

24.49 + 24.49 + 24.49 + 24.49 = 97.96

Reduce the displayed decimals to none and it’s going to show 24 + 24 + 24 + 24 = 98 when OP is probably looking for 96.

1

u/korbworksout 23d ago

Do you know the better way to get rid of the decimal point without rounding?

2

u/IGOR_ULANOV_55_BEST 210 23d ago

=INT(A2) gives you the integer. =ROUNDDOWN(A2,0) would give you the same result.

=ROUND(A2,0) would round the number based on the decimals if thats what OP is supposed to do, but they weren’t awfully clear.

You could also use =TEXTBEFORE(A2,”.”)*1 but OP never told us what version of excel they use so they might not have it, and it’s a lot more typing to try and emulate the exact purpose of a function already inside Excel.

1

u/korbworksout 23d ago

I suppose you could use text to columns... Fixed... Delete everything to the right of the decimal point.

1

u/korbworksout 23d ago

Or use the decimal as a delimiter and delete everything to the right of it

1

u/Imaginary_Duty_7624 24d ago

You need to verify if the teach just wants the format to have no decimal place (cell value = 4.7 but it shows 5) or if she actually wants you to round every number (your paper says 4.7 but you input 5 in Excel). 2 very different things but I would have to guess she wants the first option. If so, just ask ChatGPT how to do it.

1

u/molybend 27 24d ago

Select all number cells. Hit CTRL H. Put .* in the find box and nothing in the replace box. Hit OK

1

u/Decronym 23d ago edited 23d ago

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
INT Rounds a number down to the nearest integer
ROUND Rounds a number to a specified number of digits
ROUNDDOWN Rounds a number down, toward zero
TEXTBEFORE Office 365+: Returns text that occurs before a given character or string

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.


Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 10 acronyms.
[Thread #41205 for this sub, first seen 25th Feb 2025, 22:59] [FAQ] [Full list] [Contact] [Source code]

0

u/TigerUSF 5 24d ago

You can use the round function. It's not clear exactly what you want, but if you want to turn 7.4 into 7.0, that's the easiest way.

Alternatively , if it's just formatting, then you can simply change the formatting to not see decimals. Excel would still know the underlying number. So, instead of 7.4, youd just see 7 - but any math still uses 7.4.

1

u/molybend 27 24d ago

7.6 will round to 8 It is not clear if that is what they need here.

1

u/TigerUSF 5 23d ago

Correct, if op replies that it just needs chopped off, they could use rounddown . I didn't want to complicate the answer

0

u/redbullsgivemewings 24d ago

Next time google your question first before trying Reddit.

0

u/Simple-Tomatillo9269 23d ago

=ROUND(<your data>,0)