• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Number Format

Hi,

I want to format a column so when i type 00101 it displays the first two zeros

i.e. it displays 00101, not 101

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 3
  • 3
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

format the cells with custom format

00000

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
see screenshot

custom-format.png
0
 
Seamus2626Author Commented:
It wont always be 00101, if it was 0101, i need it to say 0101

So i need excel not to take away zeros, no matter how many are there

Thanks
Seamus
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
In that case, start the data entry with a ' sign. The data will be stored as text, not numbers, but the zeros will stay as you enter them.
0
 
spidey23Commented:
You could format it as TEXT instead.

But that might affect your formulas, give it a try and report back.
0
 
Seamus2626Author Commented:
Problem is teylyn, im looking for it to be automated

Can i instruct the column to start any data entry with ' in front

Thanks
Seamus
0
 
Seamus2626Author Commented:
perfect, done.

Thanks
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now