Or give it a custom format like

00000

(as many 0's as you need)

rockfam8 wrote:

how can i display preceding zeros in excel without formatting as text?

--

Dave Peterson