Turn on thread page Beta

    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
    Offline

    8
    ReputationRep:
    (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.
    Offline

    0
    ReputationRep:
    (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.
 
 
 
Poll
Do protests make a difference in political decisions?
Useful resources

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.