W
Walter Briscoe
I am running some VBA in Excel 2003.
I have a couple of cells. Each has General format and is empty.
I write "1.5" to both.
In one case the cell is bold and the value is rendered as "2".
If I remove bold, the value is rendered as "1.5".
In the other, the cell is not bold and the value is rendered as 1.5.
Ah ha. It is a question of room to fit the value.
Let me see if I can construct a simple macro to show the behavior.
In a new workbook, step through the following code:
Columns("A:A").ColumnWidth = 1 ' Make [A1] narrow
ActiveCell = "1.5" ' [A1] is rendered as "2"
Columns("A:A").ColumnWidth = 3 ' [A1] is rendered as "1.5"
I would appreciate a pointer to appropriate documentation.
Later!
It is documented in <http://support.microsoft.com/kb/182197>
Now I understand what is happening, I can adjust to it.
I have a couple of cells. Each has General format and is empty.
I write "1.5" to both.
In one case the cell is bold and the value is rendered as "2".
If I remove bold, the value is rendered as "1.5".
In the other, the cell is not bold and the value is rendered as 1.5.
Ah ha. It is a question of room to fit the value.
Let me see if I can construct a simple macro to show the behavior.
In a new workbook, step through the following code:
Columns("A:A").ColumnWidth = 1 ' Make [A1] narrow
ActiveCell = "1.5" ' [A1] is rendered as "2"
Columns("A:A").ColumnWidth = 3 ' [A1] is rendered as "1.5"
I would appreciate a pointer to appropriate documentation.
Later!
It is documented in <http://support.microsoft.com/kb/182197>
Now I understand what is happening, I can adjust to it.