Cell alignment left means positive, right means negative

I don't believe there is a built in Excel function that can read alignment. VBA can readily read the alignment property via the Range.HorizontalAlignment property https://docs.microsoft.com/en-us/off...ontalalignment

Please try..

Align left cells content.
Then use numbere format similar to
#,##0.00;* (#,##0.00)

Regards.


Edit: Seem I mis-understood again, sorry. T_T
could you please upload a sample of file ?

To convert the left aligned numbers to negative values (within the cells containing the aligned numbers), give the following procedure a try (this looks longer than it actually takes to do)...

1) Type -1 in an unused cell
2) Select that cell and press CTRL+C to copy it
3) Select the entire column containing your left and right aligned numbers
4) Press CTRL+F to bring up the Find dialog box
5) Click the "Options>>" button
6) Click the "Format.." button
7) Select the "Alignment" tab
8) Click down arrow on the "Horizontal" drop down
9) Select "Left (Indent)" from the list
10) Click the "OK" button
11) Click the "Find All" button
12) Press CTRL+A (this selects all the left aligned cells)
13) Click the "Close" button
14) Click the down arrow on the "Paste" button (located on the Home tab)
15) Click the "Paste Special.." item
16) Select the "Multiply" option button
17) Click the "OK" button

All your left aligned numbers should now be right aligned negative values. You can clear the cell you put the -1 in.

another way you can use is get.cell

go to formula --> name manager ---> click define and give name as alignment now in the refers to part type ==GET.CELL(8,Sheet1!$A1)
assuming cells whose alignment you want to check is in A1 now close name manager

go to C1 and type =alignment if formula gives 1 then its right alignment and if its two then its left alignment