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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special 5
Customise Date Format 5
Printing of Borders 0
Excel 2000 and Vista 12
Excel 2000 to Excel 2007 1
Comments 2
Word 2000 and Windows Vista 2
Office 2000 and Windows Vista 3

Top