Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2020, 12:19 PM
MimiCush MimiCush is offline Right and Left justification Windows 10 Right and Left justification Office 2013
Novice
Right and Left justification
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default Right and Left justification

I am using Excel 2013. I have a column in a table that is defined as text. It will usually hold a whole number and I want it right justified. At times there will be text and I want this left justified. I have the column formatted as right justified. I had a brilliant idea to conditionally format it when it is not numeric as left justified. Unfortunately, that is not an option of conditional formatting.

Any ideas?
Reply With Quote
  #2  
Old 04-29-2020, 03:32 PM
Logit Logit is offline Right and Left justification Windows 10 Right and Left justification Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Use the Worksheet_Change Event (in the sheet module) to check for that column.

If not numeric then macro code to right justify, otherwise it will always be left justified.
Reply With Quote
  #3  
Old 04-30-2020, 04:50 AM
p45cal's Avatar
p45cal p45cal is offline Right and Left justification Windows 10 Right and Left justification Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Try removing all justification formats from that column, it should look after itself.
Reply With Quote
  #4  
Old 04-30-2020, 06:58 AM
MimiCush MimiCush is offline Right and Left justification Windows 10 Right and Left justification Office 2013
Novice
Right and Left justification
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default Thank you

Quote:
Originally Posted by p45cal View Post
Try removing all justification formats from that column, it should look after itself.
I was overthinking. So simple. Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
right to left and left to right icon missing in paragraph section mh2019 Word 1 06-04-2019 11:53 AM
Right and Left justification Justification within a table drgt Word Tables 6 12-30-2016 03:29 PM
Right and Left justification Justification FredW Word 5 03-10-2016 05:39 PM
Right and Left justification Justification in tables mminten Word Tables 1 10-26-2012 01:39 AM
Justification not working right? kmsimmonds Word 1 08-14-2012 04:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft