Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel decimal formating problems
Hello,
I have a small problem in my excel VBA application. In above expresion: Dim A as Double A = A + 1 I want to see A in A.0 format Everything is ok then A is 0.1 or 0.2 .... 0.9 But when I have total value ".0" is missing I was tring to make a format like: A = Format (A, ""###0.0") or A = Round (A, 1) but it is not working. This value 1.0 I want to write in Excel Cell, but there is only 1. Thanks in advance Maro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel decimal formating problems
You'll want to change the numberformat of the cell:
With worksheets("sheet1").range("a1") .numberformat = "###0.0" .value = A End with wrote: Hello, I have a small problem in my excel VBA application. In above expresion: Dim A as Double A = A + 1 I want to see A in A.0 format Everything is ok then A is 0.1 or 0.2 .... 0.9 But when I have total value ".0" is missing I was tring to make a format like: A = Format (A, ""###0.0") or A = Round (A, 1) but it is not working. This value 1.0 I want to write in Excel Cell, but there is only 1. Thanks in advance Maro -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating a decimal number | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Formating decimal numbers | Excel Discussion (Misc queries) | |||
Help with formating cells (decimal places) | Excel Worksheet Functions | |||
Formating decimal and date | Excel Worksheet Functions |