Display same length of equal number of Characters in excel cell

[sanits591]

In excel column i have same number of characters e.g. 6 characters but in alpha numeric mode in each excel cell of the column.The appearance of the characters are not of same width.

Can i make the changes using some vba codes, so that it looks same of the same width as the number of characters are same in each cell.

Thanks

 

[sykes]

Try using one of the "Monotype" fonts, such as "Courier."
These are designed for users who want to work in exact columns, and are designed such that each character is of exactly equal width.

 

[sanits591]

Thanks!

But i do not want to use the courier font because the appearance of the entire sheet changes, which i can not afford.

Is there any other alternate to this by using the Calibri, or times new roman?

 

[sykes]

I'm afraid I don't know of any - but some others on the board might have an idea.


Anyone else like to proffer some more help?

 

[Peter_SSs]

But i do not want to use the courier font because the appearance of the entire sheet changes, which i can not afford.

Could you use one of these 'uniform width' font just in the column in question?

 

[sanits591]

Thanks! The only solution seems to be using the "Uniform Width" fonts for the column, like courier new or terminal type uniform width fonts.