Numeric formatting in XL

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Mustang replied

2 June 2009, 11:28
Originally posted by thunderlizard View Post

Go to Format -> Cells
On the Number tab, select Custom
In the Type box, enter 0000

Originally posted by lightng View Post

Select cells / rows / columns you wish to apply the formatting to then...

from the menu choose Format - Cells - Custom (may depend on version of excel) Enter a custom format of 0000

That should do it.

Bingo!! Many thanks for your help!!
Leave a comment:
lightng replied

2 June 2009, 11:20
Beaten to it LOL
Leave a comment:
lightng replied

2 June 2009, 11:20
Select cells / rows / columns you wish to apply the formatting to then...

from the menu choose Format - Cells - Custom (may depend on version of excel)

Enter a custom format of 0000

That should do it.
Leave a comment:
Menelaus replied

2 June 2009, 11:18
Originally posted by Mustang View Post

Can you expand on that? Are you referring to conditional formating?

Yup.
Leave a comment:
thunderlizard replied

2 June 2009, 11:17
Go to Format -> Cells
On the Number tab, select Custom
In the Type box, enter 0000
Leave a comment:
Mustang replied

2 June 2009, 11:05
Originally posted by Menelaus View Post

IF statement with LEFT, RIGHT (etc)?

Can you expand on that? Are you referring to conditional formating?
Leave a comment:
Menelaus replied

2 June 2009, 11:02
Originally posted by Mustang View Post

Is there a way I can format a cell in Excel so that the data shown will always contain the same number of digits?

E.g

Numbers in the range 0-9 will display as: 000x

Numbers in the range 10-99 will display as: 00xx

etc

TIA

IF statement with LEFT, RIGHT (etc)?
Leave a comment:
Mustang started a topic Numeric formatting in XL

2 June 2009, 11:02
Numeric formatting in XL

Is there a way I can format a cell in Excel so that the data shown will always contain the same number of digits?

E.g

Numbers in the range 0-9 will display as: 000x

Numbers in the range 10-99 will display as: 00xx

etc

TIA
Tags: None