I want to add a number without a decimal point in the number affected
I want to add a number without a decimal point in the number affected
Did you try right click on the cells, format number > number tab> select number in list then click the thousand separator and set decimals to say 4 or 5
Happy with my advice? Click on the * reputation button below
hi shimaa01234. format cells? right click those cells from A3:A19 -> Format cells -> Number. check on the Use 1000 Separator (,). then decide how many decimals you wish to see. if your wish is to place as many decimals as possible without seeing extra zeroes, then:
Format cells -> Custom
#,##0.########
put as many hexes in the back as you like.
#,##0.###
this above for eg is to see 3 decimals if there are.
for eg.
1,245.739
5,321.21
#,##0.000
this is to see 3 decimals no matter what. so
1,245.739
5,321.210
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you very much, Mr. "crooza"
Thank you Mister "benishiryo"
Great solutions
God bless you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks