Jump to content

  • Sign up for free and receive a month's subscription

    You are viewing this page as a guest. That means you are either a member who has not logged in, or you have not yet registered with us. Signing up for an account only takes a minute and it means you will no longer see this annoying box! It will also allow you to get involved with our friendly(ish!) community and take part in the discussions on our forums. And because we're feeling generous, if you sign up for a free account we will give you a month's free trial access to our subscriber only content with no obligation to commit. Register an account and then send a private message to @dave u and he'll hook you up with a subscription.

Techie Help required

sir roger

By sir roger,
in TNF - Techy Nerd Forum

 Share

Recommended Posts

sir roger Grand Master

sir roger

Posted
Posted

Apologies if this is really easy , but I don't use Excel much.

 

My excel is set up to drop the nought off the end of numbers , but I don't want to.

 

If I key 4021.30 I want it to look like that not 4021.3

 

Have had a twiddle with format / numbers but can't get it to change.

 

Any help would be appreciated.

Link to comment
Share on other sites
Redder Lurtz Grand Master

Redder Lurtz

Posted
Posted
Apologies if this is really easy , but I don't use Excel much.

 

My excel is set up to drop the nought off the end of numbers , but I don't want to.

 

If I key 4021.30 I want it to look like that not 4021.3

 

Have had a twiddle with format / numbers but can't get it to change.

 

Any help would be appreciated.

 

Highlight the entire column, right click on it somewhere, click on "Format Cells," select "Number" and choose from the dropdown box how many decimal places you require.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...