It thinks the number is text. Take a look at this:
https://excel.tv/right-align-indent-numbers-in-excel-excel-tips/
> On Aug 4, 2022, at 2:26 PM, charles meyer wrote:
>
>
> Hi All,
>
> Thank you for sharing your thoughts,
>
> I have the name of s tpary namely 113 but it appears flush right
Hi All,
Thank you for sharing your thoughts,
I have the name of s tpary namely 113 but it appears flush right in the
cell instead of flsusd left.
I need to get this sperachset out in the next couple of hours and this is
holding it up.
How do I make this flush left in the cell?
I'm on Excel 36
It seems to be alphabetizing your header row of row 1.
Try first freezing the top row. (*View *tab, click *Freeze Top Row*.)
Then try the suggestion from Tim before:
"Highlight the column you want to sort on. Excel will ask if you want to
expand you selection. Select expand and sort. If you have
Tim,
Worked perfectly except that it then places the named column as an entry in
the rows.
Ex. 1st Column is Last Names 2nd Column is First Name 3rd Column is Story
Name Third Column is email address 4th colum is phone # etc.
What happens is it alphabetizes all the name and other columenbspoerfl
Alternatively, use the Filter feature, it adds sorting controls to each column
and maintains the integrity of the rows.
On 8/2/22, 3:41 PM, "Code for Libraries on behalf of Tim McMahon"
wrote:
Highlight the column you want to sort on. Excel will ask if you want to
expand you select
One more caveat - if your data one or more blank rows, that can prevent the
entire sheet from being included in the sort. Watch for that.
Melissa Belvadi
mbelv...@gmail.com
On Tue, Aug 2, 2022 at 7:41 PM Tim McMahon wrote:
> Highlight the column you want to sort on. Excel will ask if you want
Highlight the column you want to sort on. Excel will ask if you want to
expand you selection. Select expand and sort. If you have a header row
that you don't want to include in the sort, use the custom sort and
check 'My data has headers'.
On 8/2/22 4:58 PM, charles meyer wrote:
My esteem
