MikeMcCollister
Board Regular
- Joined
- May 6, 2020
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
I have just switched a spreadsheet from Calibri as the font to Aptos Narrow. Now that I have switched, I am having some minor alignment issues. I have some cells stacked to have Week 1 through Week 5 and then a speical case where a week has not been defined yet. When it is not defined, I use an em dash, with Calibri would be the same width of a number. Now with Aptos Narrow, it is not the same width. See image to see that "Week –" does not perfectly align with "Week 5".
Is there any way to format the cell so that the em dash, or even a period will fill the width of a number?
The custom formatting that I have for the the cells is as follows:
_("Week" 0_);_("ERROR" -0_);_("ERROR" 0_);_("Week" @_)
Thanks,
Mike
Is there any way to format the cell so that the em dash, or even a period will fill the width of a number?
The custom formatting that I have for the the cells is as follows:
_("Week" 0_);_("ERROR" -0_);_("ERROR" 0_);_("Week" @_)
Thanks,
Mike