Format is fine for appearance. However I want the number to only be 7 digits.
--
Jim at Eagle


"Jarek Kujawa" wrote:

try to reformat the cell where STaxRate is stored:

1) by hand, OR

2) name the cell STaxRate and then:

Range("STaxRate").NumberFormat = "0.0000000"



On 23 Mar, 19:51, Jim at Eagle
wrote:
When, with this,
STaxRate = Application.Round(TTax / SubTotal, 7)
While in code the number is rounded to 7 digits but when posted to a cell in
worksheet it's stored at 16 digits.
How can I get my rounded number to a cell and still be rounded?
Thanks
--
Jim at Eagle