Did you try text format?
you can give text format to range by selecting text in format cell option
On 16/09/2011, John Holland wrote:
> I have formatted a column in a spreadsheet as Text. With VBA i am
> writing a string variable into a cell of that column. The string
> variable happens to cont
I have formatted a column in a spreadsheet as Text. With VBA i am
writing a string variable into a cell of that column. The string
variable happens to contain a number and i get the green triangle in
the particular cell indicating that i am writing a number as text.
However, it is formatted as a
