in the phone number cell and I cant cause by default when I press enter zero is omitted
M muse calliope May 7, 2005 #1 in the phone number cell and I cant cause by default when I press enter zero is omitted
N Nick Hodge May 7, 2005 #2 Muse Pre-format the cells as text (Format>Cells...>Text) or prefix with a single apostrophe ('), this will not show but will retain the leading zero -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
Muse Pre-format the cells as text (Format>Cells...>Text) or prefix with a single apostrophe ('), this will not show but will retain the leading zero -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
