Formula To Solve Columns With Multiple Data Types

[muhammad susanto]

hi all..

i have problem currently within my dataset there is a column that contains both percentage & numerical data types.
my sheet name is 'new adku' with name field 'Target'
i want to calculate but keep in different types.
i want to decimal number convert to be percentage number and number to be whole number
here the illustration layout

Book1
	C	D	E
1	Target	Output wanted	type data
2	0,1	10,00%	percentage
3	0,19	19,00%	percentage
4	0,65	65,00%	percentage
5	6,75	6,75%	percentage
6	123,5	123,50%	percentage
7	1000	1000,00	whole number
8	50	50,00	whole number
9	15	15,00	whole number
10	67626	67626,00	whole number
11	12345	12345,00	whole number
new adku

i hope someone would help me getting out this problem..
susant

 

[muhammad susanto]

hi alan, thank you very much. it's great solution for me.
and for Automatrix, thanks for alternative great solution.