| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display 2 scales on left and right? | Charts and Charting in Excel | |||
| Display a cell to the left with some changes | Excel Worksheet Functions | |||
| Display error msg when cells left blank | Excel Programming | |||
| Display zeros to the left of a number | Excel Programming | |||
| how to display zero at the left hand of a code in a cell say 045 | Excel Discussion (Misc queries) | |||
Linear Mode
