Numbers padded to 7 characters in Microsoft Excel

Question

I need the EEID "0" Padded to 7 characters in Excel. For example the first one will be 0000001, the 2nd will be 0000215, and so on... Not sure what the formula is? Thanks EEID 1, 215, 6261, 89898

Alternately use custom formatting on those cells with: `0000000` — tigeravatar, Jan 12 '16 at 15:06

score 2 · Accepted Answer · answered Jan 12 '16 at 15:09

2

Format the cells as Custom > 0000000:

answered Jan 12 '16 at 15:09

Gary's Student

95,722
10
59
99

Numbers padded to 7 characters in Microsoft Excel

1 Answers1