Leading Zeros in Numbers

[Francina]

Hi there

I need to add leading zeros in a cell in a large file in Numbers and I have no idea how to do that. Can someone please help me?

Thanks
Francina

 

[pigoo3]

I can show you how it's done in Open Office:

See under "Options" where it says "Leading zeroes". Maybe Numbers has something similar…or you could download & use Open Office (it's free)!

- Nick



p.s. Moved thread to better location.

 

[cradom]

I don't see anything in Preferences or Help. Maybe someone else knows?

 

[MacInWin]

Click on the cell you want to format. Then in the right column, click on the Cell options tab (if the right bar isn't showing, click on the paintbrush icon, top row, right side to get it to show). Now under Data format, click the box just under it to open a new window and select "Create Custom Format."

In the resulting window click on the Custom Format window on the little down pointer and select the number of digits you want to show and then "Show zero for unused digits" and all unused digits ahead of your data will show as zeros.

Hope that helps some.

EDIT: Where I said "click on the cell" what I should have said is "Select the cell(s) you want to format." You don't have to do the formatting one cell at a time.