Solved

EXCEL - Zero filling

Posted on 2016-09-27
5
63 Views
Last Modified: 2016-09-30
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
Comment
Question by:tmajor99
  • 3
5 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41817916
Simply apply formatting to increase the number of decimal places. On the Home Ribbon in the Number group.
0
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 41817919
Hi
select the numbers

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

Regards
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41817924
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
 
LVL 7

Accepted Solution

by:
DPatel earned 500 total points
ID: 41819116
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
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41823067
Not even assistance points for Rgonzo and me??? We gave the same solution just a different route to applying it.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question