LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default format variable to 3 decimal

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:)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time in 24 hour format to produce hours in decimal format Hercdriver Excel Worksheet Functions 11 December 29th 09 02:06 AM
How to type format time in decimal format & calculate Cheyenne Excel Discussion (Misc queries) 1 February 12th 09 11:54 PM
Format percentage as a decimal BSAT Student Excel Discussion (Misc queries) 2 October 20th 05 09:48 PM
Entering numbers with variable decimal places. Jack Excel Worksheet Functions 8 February 2nd 05 04:35 AM
variable as Currency two decimal places Max Bialystock Excel Programming 2 May 10th 04 10:48 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"