Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How can I format a cell in Numbers to have leading zeros in a number?

I imported a spreadsheet from Excel (Office 2014, Win 7) through iCloud and some numbers were formatted to have leading zeros (012358) in the original Excel file but the leading zero format was lost in Numbers. Is there a way to format cells to have a number displayed with the leading zero in Numbers? The leading zero is part of an identification and is important to the numbers (0027 is not the same as 27 in these records).


thanks,


Bob

Posted on Jun 25, 2014 9:20 AM

Reply
4 replies

How can I format a cell in Numbers to have leading zeros in a number?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.