| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Cells
Spreadsheet with one column having reference numbers as either whole
number or as two numbers divided by slash. How can you get both options to right align? TIA ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
Highlight the column, then right-click FormatCells AlignmentTab in the
Horizontal window, choose RIGHT ok Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: Spreadsheet with one column having reference numbers as either whole number or as two numbers divided by slash. How can you get both options to right align? TIA ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
Should have mentioned Excel 2000. ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ Gerry Cornell wrote: Spreadsheet with one column having reference numbers as either whole number or as two numbers divided by slash. How can you get both options to right align? TIA ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
CLR
Thanks but that only corrects those cells not conforming. I am looking for a solution where that becomes unnecessary?. The same problem also arise with alphanumeric reference numbers. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ CLR wrote: Highlight the column, then right-click FormatCells AlignmentTab in the Horizontal window, choose RIGHT ok Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: Spreadsheet with one column having reference numbers as either whole number or as two numbers divided by slash. How can you get both options to right align? TIA ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
Hi Gerry...........
As long as you pre-format the empty cells as I've suggested, the entry of new values will also be right-aligned. Please describe what you've tried and how it is acting differently than what I've described........ Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: CLR Thanks but that only corrects those cells not conforming. I am looking for a solution where that becomes unnecessary?. The same problem also arise with alphanumeric reference numbers. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ CLR wrote: Highlight the column, then right-click FormatCells AlignmentTab in the Horizontal window, choose RIGHT ok Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: Spreadsheet with one column having reference numbers as either whole number or as two numbers divided by slash. How can you get both options to right align? TIA ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
CLR
I tested what you suggested and it worked. Thank you. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ CLR wrote: Hi Gerry........... As long as you pre-format the empty cells as I've suggested, the entry of new values will also be right-aligned. Please describe what you've tried and how it is acting differently than what I've described........ Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: CLR Thanks but that only corrects those cells not conforming. I am looking for a solution where that becomes unnecessary?. The same problem also arise with alphanumeric reference numbers. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Cells
Happy to help Gerry............thanks for the feedback............
Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote in message ... CLR I tested what you suggested and it worked. Thank you. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ CLR wrote: Hi Gerry........... As long as you pre-format the empty cells as I've suggested, the entry of new values will also be right-aligned. Please describe what you've tried and how it is acting differently than what I've described........ Vaya con Dios, Chuck, CABGx3 "Gerry Cornell" wrote: CLR Thanks but that only corrects those cells not conforming. I am looking for a solution where that becomes unnecessary?. The same problem also arise with alphanumeric reference numbers. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Linear Mode
