Send to excel: numbers appear as text

[paul_ripley]

Hello

When I send to excel on the server then the numbers are exported in General format

When I send to excel from the Access Point then the numbers look ok at first, although they are showing in 'Protected View' .  As soon as I click 'Enable editing' then the numbers appear as text format.

Do you know if there is a way to have the numbers from the Access Point appear as numbers rather than text (is it the protected view that is the issue?)

Thanks

Paul

[squeakie_pig]

Set the number format in the Numbers tab instead of using Expression Default

[paul_ripley]

Hi

It is already set as 'Number' in the document settings.  Is there somewhere else this need to be set?

[squeakie_pig]

The Number tab in the Chart Properties.

[paul_ripley]

This field is a dimension, not an expression.  When I change the Numbers tab, it just affects the Expression numbers not the format of the dimension

[squeakie_pig]

You could force it by making it a calculated dimension

num#(fieldname,'#,##0') or if that doesn't work, force it in the script, num(EVALUATE(fieldname),'#0')