In pages: $1,746.50 is incorrectly displayed as $1,746.5
I can't figure out how to just add the zero that should be there. Maybe I should use Microsoft Word instead?
I'm using a 2015 MacBook Pro that runs macOS Monterey.
The version of Pages I'm using is 13.1
[Edited by Moderator]
MacBook Pro 15″, macOS 12.7
I can't replicate this via any normal means... certainly if the cell F2 is entered either as a numeric entry or as a formula such as D2 x E2
The only way I can get it to display in the way you show it is if I specifically set the cell to a text string, such as:
="$1,746.5"
where you're explicitly telling Pages how to show the value, overriding any currency formatting.
So the big question is: what formula is behind that cell? It might help show some other corner case I'm not thinking of.
I can't replicate this via any normal means... certainly if the cell F2 is entered either as a numeric entry or as a formula such as D2 x E2
The only way I can get it to display in the way you show it is if I specifically set the cell to a text string, such as:
="$1,746.5"
where you're explicitly telling Pages how to show the value, overriding any currency formatting.
So the big question is: what formula is behind that cell? It might help show some other corner case I'm not thinking of.
In my installation of Monterey 12.7.6 and Pages v13.1, I have the same Data Format settings and receive 2-digit cents for each dollar entry. In System Preferences > Language & Region, it is set to English as the preferred language; United States, and the currency example on that panel shows 2-digit cents. For those highlighted cells, and if relevant, check your formulas and the functions used to confirm rounding to a single digit is not involved.
For macOS Sequoia v15.5 and Pages v14.4, with the same settings, I get 2-digit cents for U.S. currency. That is by default with the observed settings.
If you are actively sharing word processing documents with those that use MS Word, then yes, you should be using Word to sustain native document formatting and avoid the functionality gap of document translation that Pages performs on export to Word.
Pages - Currency Incorrect Format
