Formatting Cells

G

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

Gerry Cornell

Should have mentioned Excel 2000.




~~~~

Gerry

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

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

Gerry Cornell

CLR

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

--

Regards.

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

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top