Copy exactly Data Validate list cell but blank cell showing 0

[pankajgrover]

I am trying to copy exactly same Data Validation lists Cells but blank cell showing 0. How to correct this 0 as blank. here is below example.. Thanks

New Microsoft Excel Worksheet.xlsx
	C	D
1	RED	RED
2	BLUE	BLUE
3	BLACK	BLACK
4		0
5		0
Sheet2

Cell Formulas
Range	Formula
D1:D5	D1	=C1

Cells with Data Validation
Cell	Allow	Criteria
C1:C5	List	=COLOR

 

[Fluff]

If col C is always text how about

=C1&""

 

[pankajgrover]

If col C is always text how about

=C1&""

Thanks its working on text , and for if source cell is numeric then how i can ?

 

[Fluff]

Try

=if(c1="","",c1)

 

[pankajgrover]

Try

=if(c1="","",c1)

Okay, its working also. Can we have also any other option without IF function to do this? Thanks

 

[Fluff]

Why, what's wrong with using if?

 

[pankajgrover]

Why, what's wrong with using if?

Nothing wrong with that, it's working good, i have 7 to 8 cells like that, so i hv to change formula with IF with all cells... i was asking for alternate option just for knowledge purpose...that's it...
But thanks so much . This forum really enhance my excel skill . Lucky to be part of this forum.

 

[Fluff]

IMOif you have cells that could be either text or numbers the IF formula is the way to go.

 

[Peter_SSs]

@pankajgrover
I have changed the 'Mark as solution' post. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message (post #3 is not a solution post) as it will help future readers. No further action is required for this thread.