Need trailing zeroes to show for range of numbers....

  • Thread starter Thread starter Sueshe
  • Start date Start date
S

Sueshe

The file I pulled into Excel for some reason cut off 2
trailing zeroes, no matter how I format it they will not
show up. There are thousands of them and I can't see
typing in each one over just to get two zeroes on the
end. Does anyone know of a way to format this so they
will show up? I have searched Microsoft online with no
help.
 
Not too much information, but try this (after saving your workbook!)
In an empty cell enter the numner 100. Edit>Copy
Select your data
Edit>Paste Special, check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
-----Original Message-----
The file I pulled into Excel for some reason cut off 2
trailing zeroes, no matter how I format it they will not
show up. There are thousands of them and I can't see
typing in each one over just to get two zeroes on the
end. Does anyone know of a way to format this so they
will show up? I have searched Microsoft online with no
help.
.
Click to expand...
Sueshe

The file must be Text so formatting the number will do no
good. You must first convert it to a number in a helper
column. Say the text number is in A2, in B2 type =A2*1
Copy this formula down then format whatever way you want.
Select the formulas and Copy and Choose Edit,
PasteSpecial, Values and this will convert the formulas to
values. You can then delete the original text numbers.

If you do not mind using VB this sub will convert the text
value to four (4) decimal places. (alter dp to suit)

Sub AddDec()
Dim c

For Each c In Selection
c.Value = Round(c * 1, 4)
c.NumberFormat = "0.0000"
Next c
End Sub


To operate the macro right-click the Sheet Tab and choose
View Code. Paste the macro into the module.
Then select the text numbers in the spreadsheet and
swiching back to the code module press F5.

Regards
Peter
 
Back
Top