[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 83
  • 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 HensonIT & Database AssistantCommented:
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 HensonIT & Database AssistantCommented:
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 HensonIT & Database AssistantCommented:
Not even assistance points for Rgonzo and me??? We gave the same solution just a different route to applying it.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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