How to use a single nonrepeating XML element in a cell formula

[Paul Smith]

Hi - is it possible to use a single nonrepeating XML element in a cell formula?

I am bringing a date field from an XML source, eg. '23/11/2009', and don't
just want to show it in a cell by itself.

I want to use it in a cell for a heading, such as 'Report date: 23/11/2009'
all as one string.

So I would like a cell formula along the lines of '="Report date: " &
{XML->ReportDateField}

How do I get access to an XML field in a formula? Is there a syntax for this?

All I can think of is to put it directly in to another cell, and make it
invisible by setting its text colour to white.

And then refer to this cell in my formula. This is a bit messy, especially
if users want to play around with the spreadsheet, and accidentally delete
this hidden cell.

Any help would be greatly appreciated.

Cheers

Paul Smith

 

[Peggy Shepard]

Hi Paul,

You can use a custom format, right click on the cell and select the number
tab - select custom.

"Report date:" dd/mm/yy

Peggy