In article ,
"rockfam8" wrote:

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

Precede your entry with an apostrophe. For example...

'012345

Hope this helps!