Display ONLY the LEFT Most 6 Charaters
 

How can i code a Cell (B4) to have only 6 charaters to be displayed ?

I want it to look like:
A 1234

(A) is ALWAYS the 1st charater and is set in the Custom Formatting as : "A "#

I set it to display the letter (A) and 1 space like "A "

There will always be 4 numerical values i need to display with the A and Space.

How can i do this ?


Corey....

Display ONLY the LEFT Most 6 Charaters
 

Change your custom format to
"A " 0000
instead of
"A " #
This will force six characters. You may also want to place some validation
on the cell to foce only whole numbers between 0 and 9999...
--
HTH...

Jim Thomlinson


"Corey" wrote:

How can i code a Cell (B4) to have only 6 charaters to be displayed ?

I want it to look like:
A 1234

(A) is ALWAYS the 1st charater and is set in the Custom Formatting as : "A "#

I set it to display the letter (A) and 1 space like "A "

There will always be 4 numerical values i need to display with the A and Space.

How can i do this ?


Corey....