I have one of my fields as a decimal (5,2) format and when I do a query statement, the output is left justified. I would like it right justified. There is a setting in MySQL for right justified, but it doesn't seem to work with decimal data types.
I have one of my fields as a decimal (5,2) format and when I do a query statement, the output is left justified. I would like it right justified. There is a setting in MySQL for right justified, but it doesn't seem to work with decimal data types.
Make sure your cells are Number Format|General and Alignment|General. They should then automatically right justify decimal values.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks