Inserting an excel sheet without the formatting.

[Radha]

Is there any way to insert an excel data to another new sheet without the
original format of the first sheet. If I have date, percentage in my first
sheet, will my second sheet keep that format or will it paste that also as a
normal text?

 

[Luke M]

When you go to copy the data, right click, choose paste special. Select the
option that best suits your need (either "value only" or "formulas")

 

[Radha]

Thank you, Luke for your quick response, I appreciate it.

Radha