Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 88
  • Last Modified:

EXCEL - Zero filling

Can someone show me how I can zero fill an excel column.  I need the decimal value to be zero filled so it is always 3 bytes long.

ColumnA                 Zero filled

4.5                     ---->  4.500
4                       -----> 4.000
4.51                  -----> 4.510
4.560               ------> 4.560
4.000               ------> 4.000
0
tmajor99
Asked:
tmajor99
  • 3
1 Solution
 
Rob HensonFinance AnalystCommented:
Simply apply formatting to increase the number of decimal places. On the Home Ribbon in the Number group.
0
 
Rgonzo1971Commented:
Hi
select the numbers

Goto
Home / Number / Increase decimal Button
<-.0
.00
click 3 times

Regards
0
 
Rob HensonFinance AnalystCommented:
As per both comments, screen shot below:
Decimal Places
If these values are needed for subsequent export to a system that needs the full value, use the following formula:

=TEXT(A1,"0.000")  then copy and paste values over the original to replace.
0
 
D PatelD Patel, Software EngineerCommented:
Select the Column for which you wanted to format numbers
Select Data Column
Next Choose the More Number Formats..... in the Number Group portion in ribbon. (or you can open Format Cells window)
More Number Formats...
Now from the Number tab choose Custom in the left pane.
Custom
Go to the Type text box and enter it as "0.000"

Now you will see the result which you wanted.
Result
Enjoy...!
0
 
Rob HensonFinance AnalystCommented:
Not even assistance points for Rgonzo and me??? We gave the same solution just a different route to applying it.
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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