Formatting Cells

[Gerry Cornell]

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

 

[Gerry Cornell]

Should have mentioned Excel 2000.




~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~

 

[Gerry Cornell]

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

 

[Gerry Cornell]

CLR

I tested what you suggested and it worked. Thank you.

--

Regards.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[CLR]

Happy to help Gerry............thanks for the feedback............

Vaya con Dios,
Chuck, CABGx3