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