Why am I losing formatting when exporting to excel?

[oscar_ortiz]

This question is posted in the archives but I can't see the attachments associated with the archives so I'm asking again.

I've got a pivot table that has custom number/date formatting applied to an expression. When I export that chart to excel I lose my formatting.

Any ideas on how to deal with this would be appreciated.

Thanks

QlikView

F1	F2	F3	Expression
date	08/17/1967	M/D/YYYY	8/17/1967
time	12:45:00	h:mm:ss tt	12:45:00 pm
dollar	12345.67	$#,##0;($#,##0)	$12,346
percent	.7952	##0.00%;-##0.00%	79.52%
dollar1	-12345.67	$#,##0;($#,##0)	($12,346)
percent1	-.7952	##0.00%;-##0.00%	-79.52%

Excel

F1	F2	F3	Expression
date	08/17/1967	M/D/YYYY	24701
time	12:45:00	h:mm:ss tt	0.53125
dollar	12345.67	$#,##0;($#,##0)	12345.67
percent	.7952	##0.00%;-##0.00%	0.7952
dollar1	-12345.67	$#,##0;($#,##0)	-12345.67
percent1	-.7952	##0.00%;-##0.00%	-0.7952
No selections

[disqr_rm]

Try with this expression:

If(F1 = 'date' or F1 = 'time', text(date(F2,F3)),text(num(F2,F3)))

Basically convert it to text first.

[oscar_ortiz]

Rakesh,

Thanks for the response. This works great with keeping the formatting in excel. But, I have now I've lost my ability to use the actual values of the numbers in excel. They've been transalted into text. Is there any way to convert the numbers and keep the formatting? Similar as to when you have Money selected on the number tab and do an export. It keeps the formatting as well as the values of the numbers.

Oscar