ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   columns reversed (https://www.excelbanter.com/excel-worksheet-functions/88514-columns-reversed.html)

lou

columns reversed
 
How do I change the column format from Z - A to a - z?

Don Guillett

columns reversed
 
datasortoptionsleft to right

--
Don Guillett
SalesAid Software

"lou" wrote in message
...
How do I change the column format from Z - A to a - z?




Jim Cone

columns reversed
 
Or possibly...
Tools | Options | International (tab)
Default direction...Left-to-right should be checked.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"lou"
wrote in message
How do I change the column format from Z - A to a - z?

lou

columns reversed
 
I found the solution in the formatting toolbar. The last icon is "sheet right
to left". How this got reset as the default I have no idea.

"Jim Cone" wrote:

Or possibly...
Tools | Options | International (tab)
Default direction...Left-to-right should be checked.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"lou"
wrote in message
How do I change the column format from Z - A to a - z?



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com