flemingg62
asked on
Formatting a Cell linked to a Pivot Table
Hi I have a cell linked to a value in a pivot table, once you format the number (to include a , I,e, 1,064) I can no longer center the linked value in the cell.( or Left Justify)
Is they any way I can center the value in the cell
Sample spreadsheet attached.
Book3.xlsx
Is they any way I can center the value in the cell
Sample spreadsheet attached.
Book3.xlsx
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
I don't see leading spaces at all in the sample. However, I do see that the cell is formatted with Custom formatting:
_-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-
The custom format has four sections separated by semi-colon
Positive value - _-* #,##0_-
Negative value - -* #,##0_-
Zero value - _-* "-"??_-
Text- _-@_-
The combination of - and _ and * at the start of each section is forcing the format to stay right aligned.
To allow for comma and centre or left aligned use custom format:
#,##0_-;- #,##0_-;_-* "-"??_-;_-@_-
_-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-
The custom format has four sections separated by semi-colon
Positive value - _-* #,##0_-
Negative value - -* #,##0_-
Zero value - _-* "-"??_-
Text- _-@_-
The combination of - and _ and * at the start of each section is forcing the format to stay right aligned.
To allow for comma and centre or left aligned use custom format:
#,##0_-;- #,##0_-;_-* "-"??_-;_-@_-
ASKER