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

Excell - zeros in front of the number

Quick question - can should I format the cells to it accepptsw zeros in front of the number?  No matter what I try it remove 0's and leaves just a number...  Drives me crazy
Please advice.
0
Tiras25
Asked:
Tiras25
  • 2
  • 2
2 Solutions
 
Patrick MatthewsCommented:
Depends on how many digits you want.  To always display, say, 5 digits, with leading zeroes if need be, use a customer number format of:

00000
0
 
Patrick MatthewsCommented:
Make that "To always display, say, at least 5 digits, ..."
0
 
Tiras25Author Commented:
Custom format.  Got it.   Is there a way to tell excell to accept whatever numbers you typing without ANY modifications?
0
 
Chris BottomleyCommented:
Use the tick mark <<< ` >>> , top left of the keyboard at the start of what you type

Chris
0
 
Tiras25Author Commented:
Perfect.  Thanks!!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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