Hi Everyone,
I've created a table in Pages and I want to enter a series of numbers into the columns. I entered 0000 (4 zeros) but when I go to the next cell, it changes to 0 (1 zero). Similarly, when I enter 0001, it changes to 1. I want the cell so read 0000, 0001, 0002, etc. but they keep changing to 0,1,2 etc. How can I get those zeros to remain?
Cheers,
Mal
iMac, OS X El Capitan (10.11)
The following setting when used for cell formatting will allow you to retain four-place number sequences (e.g. 0000, 0001, etc.).
The following setting when used for cell formatting will allow you to retain four-place number sequences (e.g. 0000, 0001, etc.).
Hi Mal,
Select the cells.
Format Panel > Cell > Data Format > Custom Format
Untick Show Separator.
Tick Show Zeros for Unused Digits.
Regards,
Ian.
Very many thanks to VikingOSX and Yellowbox - this solved the issue. Brilliant!
Very many thanks to VikingOSX and Yellowbox - this solved the issue. Brilliant!
Hi Mal,
Glad to help. Please keep posting in Apple Support Communities.
Regards,
Ian.
Entering numbers into a table in Pages
