PC Review


Reply
Thread Tools Rate Thread

Display ONLY the LEFT Most 6 Charaters

 
 
Corey
Guest
Posts: n/a
 
      19th Jun 2007
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....


 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      19th Jun 2007
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....
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display 2 scales on left and right? Eric Microsoft Excel Charting 1 29th Jan 2010 07:25 AM
Display a cell to the left with some changes cmatera Microsoft Excel Worksheet Functions 1 16th Sep 2008 05:33 AM
Secondary display on the left Lok Tak Cheong Windows XP Video 0 16th Apr 2007 08:11 AM
Display Shifted Left =?Utf-8?B?QWFyb24gU2NoZXJiaW5n?= Windows XP Video 0 16th Oct 2004 07:11 AM
Right-To-Left Fonts display !!! Hady Microsoft Access Forms 0 26th May 2004 07:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:44 PM.