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: 28
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: 307
Logit will become famous soon enough
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 p45cal is offline Right and Left justification Windows 10 Right and Left justification Office 2019
Expert
 
Join Date: Apr 2014
Posts: 392
p45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the rough
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: 28
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 - Senior Forums

All times are GMT -7. The time now is 01:46 AM.


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