But that won't help if you've already entered the number. Formatting as
text is fine if you do it before you enter the number.
--
David Biddulph

wrote in message
ups.com...
You can right click on the cell, format cell, and select that cell
type as "text".

On May 17, 8:42 am, Matt wrote:
How do I display the number 00036 as such instead of excel
automatically formatting it as 36?