Microsoft Excel Help!

Watch this thread
This discussion is closed.
Unregistered69
Badges:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#1
Report 18 years ago
#1
help, in microsoft excel, i want teh values to be to 2 decimal places, but if i type in 56.00, it automatically changes to 56 when i click off. is there any way that i can stop this? thanks
0
sock
Badges: 8
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#2
Report 18 years ago
#2
(Original post by Unregistered69)
help, in microsoft excel, i want teh values to be to 2 decimal places, but if i type in 56.00, it automatically changes to 56 when i click off. is there any way that i can stop this? thanks
There should be 'increase decimal' and 'decrease decimal' buttons in the top right. If you can't find them, just search in the help section.
0
GelZork
Badges: 0
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#3
Report 18 years ago
#3
(Original post by Unregistered69)
help, in microsoft excel, i want teh values to be to 2 decimal places, but if i type in 56.00, it automatically changes to 56 when i click off. is there any way that i can stop this? thanks
or select the appropriate cell, column or row and click - format - cell, then the number tab, from the list below select number and then there should be a decimal places box, change the amount there.
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Y13's - If you haven't confirmed your firm and insurance choices yet, why is that?

I am waiting until the deadline in case anything in my life changes (10)
21.28%
I am waiting until the deadline in case something else changes (e.g. exams/pandemic related concerns) (4)
8.51%
I am waiting until I can see the unis in person (4)
8.51%
I still have more questions before I make my decision (5)
10.64%
No reason, just haven't entered it yet (12)
25.53%
Something else (let us know in the thread!) (12)
25.53%

Watched Threads

View All