Inserting an excel sheet without the formatting.
 

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?

Inserting an excel sheet without the formatting.
 

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")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Radha" wrote:

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?

Inserting an excel sheet without the formatting.
 

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

Radha

"Luke M" wrote:

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")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Radha" wrote:

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?