Thread: Dropping 0
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default Dropping 0

Peter

Format the cell as "text" before you enter data or proceed your entery with
an apostrophe " ' ".

Mike Rogers

"Peter F" wrote:

Hi All,

i can't work out why my cells keep dropping leading zeors or what i need to
do to solve the provlem i.e. if i typ in 08070997226 into a cell it drops the
leadin 0.

Please could someon help.

Regards.

--
Flinty