View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default 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....