- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Coaching Changes
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel help
Posted on 10/3/25 at 8:47 am
Posted on 10/3/25 at 8:47 am
Anybody know how to put a .0 at the end of a number regardless if there is another value after the decimal?
For example
Cell 1: 736.342
Is there a way I can format it to say 736.0
I know I can manually do it but good lord that's alot of cells to change
For example
Cell 1: 736.342
Is there a way I can format it to say 736.0
I know I can manually do it but good lord that's alot of cells to change
2
Posted on 10/3/25 at 8:52 am to Codythetiger
Insert a column next to the data values, paste this formula, and adjust the formula for all data in the range. Next, copy the results (say from column B) and paste as values only over the original range and delete column B.
=INT(A1) & ".0"
=INT(A1) & ".0"
This post was edited on 10/3/25 at 8:55 am
Posted on 10/3/25 at 8:53 am to Codythetiger
Round down formula?
Posted on 10/3/25 at 8:55 am to whodatdude
This guy here
That looks to do it, thank you!!
That looks to do it, thank you!!
Posted on 10/3/25 at 9:22 am to bluebarracuda
quote:
Round down formula?
Was my thought as well. Use either =ROUND(A1,0) or =ROUNDDOWN(A1,0); then adjust the formatting for that column to have 1 decimal place
Posted on 10/3/25 at 9:35 am to whodatdude
Secondary question
I have one locked spreadsheet where the cost need to have 4 decimal places and the spreadsheet I'm copying the numbers from have 2 decimal places.
For example.
Cell 1 in the unlocked spreadsheet = 1435.91
Okay no problem, I adjusted the cells to show 4 decimals so now it looks like 1435.9100
However, when I go to paste into the locked spreadsheet it takes off the 0's and only has 2 decimal places.
How can I get the locked spreadsheet to hold the 4 decimal places?
It looks weird in the unlocked spreadsheet because the value of the cell still shows 1435.91 even when it has the extra 0's in it
I have one locked spreadsheet where the cost need to have 4 decimal places and the spreadsheet I'm copying the numbers from have 2 decimal places.
For example.
Cell 1 in the unlocked spreadsheet = 1435.91
Okay no problem, I adjusted the cells to show 4 decimals so now it looks like 1435.9100
However, when I go to paste into the locked spreadsheet it takes off the 0's and only has 2 decimal places.
How can I get the locked spreadsheet to hold the 4 decimal places?
It looks weird in the unlocked spreadsheet because the value of the cell still shows 1435.91 even when it has the extra 0's in it
Posted on 10/3/25 at 10:50 am to Codythetiger
Select the range and right-click and click Format Cells. Choose the Custom category and enter #.0000 as the Type.
Posted on 10/3/25 at 11:17 am to Brisketeer
That still isn't working. It's still reducing the numbers back to 2 decimals in the locked spreadsheet.
It's strange because I'm putting 2 different spreadsheets into this locked spreadsheet. Both unlocked spreadsheets are auto generated but they are auto generated out of two different systems this month since we are in the middle of a system switch.
The 1st auto generated spreadsheet works perfectly, because it was custom designed to match this locked spreadsheet.
The 2nd spreadsheet I'm trying to copy all this other data into is the issue. It's being exported out of salesforce and it sucks arse
It's strange because I'm putting 2 different spreadsheets into this locked spreadsheet. Both unlocked spreadsheets are auto generated but they are auto generated out of two different systems this month since we are in the middle of a system switch.
The 1st auto generated spreadsheet works perfectly, because it was custom designed to match this locked spreadsheet.
The 2nd spreadsheet I'm trying to copy all this other data into is the issue. It's being exported out of salesforce and it sucks arse
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News