Hi,

Before typing the number beginning with zero, convert that cell format to
text (Format-- Cells--Number-- select Text in the list) otherwise begin
with ' (single quote) and then type the number ('012345).

Hope this will clear your doubt.

Regards,
Soundar.

"tash" wrote:

I am keeping a list of account numbers and sort codes, but every time i type
a number beginning with a 0 it is auto removed!!