Character code hex 2193 is a down arrow, subject Font and not particularly
an "Excel" arrow

Using VBA

Range("A1").Value = ChrW(&H2191)
Range("A2").Value = ChrW(8593)

other arrows from 8592 to 8597

Regards,
Peter T



"tommo_blade" wrote in message
...
Hi,
I am dynamically creating a spreadsheet using a Perl program, I
simply create a <TAB delimmited file with a .xls extension, when
opened I have the basic requirements of my excel spreadsheet, there is
one piece of information that I cannot replicate and that is how I can
force the Excel 'up arrow' symbol (character code 2193) in the
spreadsheet, simply putting 2193 does not represent an 'up arrow' when
the spreadsheet is opened, it reads '2193' literally - do I have to
quote it or something else or is it even possible...

help appreciated, Mark.