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....

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....
>
>
>