Format as Text before entering the numeric characters, or precede them
with an ' (apostrophe)

Janice wrote:
Hi all,
I am working on a spreadsheet that as a column telephone numbers, however,
the '0' at the beginning of every number has been dropped.
How can I insert this so every number begins with a '0' ( the std's of the
numbers are from all over the UK so vary greatly)
Many thanks to anyone that can help me.