Excel Function

M

marie

I am trying to keep the number 0 in front of my other numbers it keeps
disappearing
 
J

Jacob Skaria

If it is 3 digit numbers

Format>Cells>Custom format >Type> 000

and then try typing the numbers

If this post helps click Yes
 
E

Eduardo

Hi,
Format, cells, custom format, type as many 0 as the total numbers including
the 0

i.e. 000123 you enter 000000
 
S

Shane Devenshire

Hi,

You really need to tell us more about your data. Is it always a given
number of characters or is that variable. The formatting tricks that have
been recommended work for numbers of the same length. To handle variable
length number highlight your input range and choose Format, Cells, Number
tab, Text. Then enter the numbers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Cannot Put A Border Around Numbered Text. What To Do? 0
You don't currently have permission to access this folder 0
Paragraph numbering in Word 1
Why do my arrows/connectors partially disappear? 0
Creating a Chart on form from selected data in query. 0
Mis-performing MP4 files in Mac PPT 1
Possible to Combine reports to's to a single box? 0

Top