Data is in Different Format and data should displaying same format in Pivot table

[Ramu]

Hi 

I have Excel table in that data having the different format in single column (Values) .while loading the same column data was displaying the  single format ,But I want to display the data all the formats in single column.

If any body know's the solutions ,Please let me know.

Thanks

Zone	Values
A-Zone	$6,000
B-zone	90%
C-Zone	25
D-Zone	SATTE

[JordyWegman]

Hi Ramu,

This is not possible with an overall number format, because that would affect the whole column. What you could do is loading the data in a crosstable (or if you work in the Data Manager, unpivot the table). For this you will get 4 columns with values and for each column you can specify the correct format.

Jordy

Climber

[Ramu]

Hi Jordy,

Thanks For Responding