format variable to 3 decimal

  • Thread starter Thread starter Wandering Mage
  • Start date Start date
W

Wandering Mage

What I am trying to do, is use a variable to as part of
the name in a Chart that is created using a macro. When I
go Round(takttime, 3), takttime is the variable, and it
will round out to 3 decimals as it is supposed to, but I
also want it to SHOW THE ZEROS UP TO # DECIMALS. So, for
instance, a 5 should show up as 5.000. The problem is, I
am not just writing to a cell, so its not like I can just
format the cell to 3 decimals and be done with it. Does
anyone know how I get this to output to include 0's when
rounding? Help is, very much, as always, appreciated!
Thanks:)
 
Use the Format function:

=Format(Round(taktime,3),"#.000")

This converts to Text and specifies the format so it can
be assigned to any String variable or to things like the
names in your chart, etc. For more info look up the
Format function and "User-Defined Numeric Formats" in VBA
help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round to 2 decimal places 2
Rounding 2 decimal Places 1
Access stripping decimal places in query 1
VBA code outputs currency value rounded to 2 decimal points 7
I'm getting unwanted rounding to integer for an average of range of cells. 2
Format a Double to have one decimal place number? 3
How to retrieve number of visible digits after decimal point in VBA 5
Format decimals in VBA function 3

Back
Top