Excel Number Formatting

C

Caz

Hi please help us..

We want to convert a number that starts with 0001 to text, but when we do
this it loses the 0's how can we do this without going down 70000 lines and
typing in the 0. Its hurting my head!
 
D

David Biddulph

A number of options, including:
Format the cells as text before you type the numbers in, or
Type an apostrophe at the beginning of the number to tell Excel to treat it
as text, or
Format the cell as 000000 if you want to display the number as 6 digits, for
example, or
=TEXT(A2,"000000") if you want to convert the number to text with 6 digits,
or
="000"&A2 if you want a text string which starts with 000 and then continues
with your existing number.
 
Top