English
|
Login & Registration
Dreevoo.com
CONTRIBUTE
FORUM
INFO
|
Programs
|
Microsoft Office
|
Microsoft Excel
| Set number of zeros in Excel's cell
Guest
Topics
Programs
Languages
Recipes
Home
Shortcuts
Microsoft Windows
Microsoft Office
Adobe Photoshop
Adobe Dreamweaver
Adobe Premiere
The Gimp
Apple software
Mobile platforms
Web services
Other applications
Programming languages
French language
Greek language
Italian language
German language
Portuguese language
Russian language
Spanish language
Vegeterian dishes
Meat dishes
Seafood
Pasta
Desserts
Drinks
Other dishes
Automotive
Magic tricks
Photography
Household
Computers
Do It Yourself
Environment and health
Technology
Space
Interesting
Science and nature
Other
Knowledge
Technology
Fun
Curiosity
Computing
Culinary
Culture
Geography
History
Languages
Science
Set number of zeros in Excel's cell
If you are working with numbers often and you also like to be organized, then this tutorial might be helpful for you.
Author:
NikMan
|
Version:
2010
| 5th August 2013 |
Comment (
5
)
1.
Open new spreadsheet and write random numbers like I did.
2.
Then select all those cells with numbers.
3.
Right click with your mouse button
on selected cells and choose
Format Cells...
4.
In a new window first choose
Custom
in Category field.
5.
In field Type write nine zeros (see the pic on the left).
In my case I want to have nine numbers. Write more or less zeros to modify the number if you want.
6.
Click
OK
when finished.
7.
We are finished.
Please login to post a comment
JessicaLange
, 5th Aug 2013, 12:54 AM
Thank you for this helpful and usable tutorial.
Mukarachi
, 6th Aug 2013, 9:13 AM
That helped me at work. Thank you NikMan.
kenaz
, 7th Oct 2021, 11:27 AM
That is useful for sure! Thanks
kenaz
, 7th Oct 2021, 11:30 AM
And if you are thinking about who could entering data for your work, then on the
https://fee4bee.com/services/office-serv....
you can find contractors who enter data quickly and without errors.
online learning made for people
Dreevoo.com
|
CONTRIBUTE
|
FORUM
|
INFO