values and format

  1. B

    Cell apparently not recognized as number; can't perform calculations - #VALUE! output

    Hello all: I have simple statistical data on an excel spreadsheet and when I try to perform calculations it, I get a #VALUE! output. The cells to which my formula refers are formatted as numbers, so I do not know what may be happening. It seems as if the data is not recognized as numbers. I...
  2. Carlo22

    Cut and paste values only? to avoid copy>paste values> select initial cells>clear cells

    Hi, I'm looking for a way to easily move only values from one cell selection to another. The formating of both the source and the destination cells are to remain the same. So far I couldn't manage to find a solution in this forum or elsewhere. Does someone here have a solution? Thanks!
  3. G

    Save only Worksheets and Values of Macro Workbook as New Workbook, Same Location

    I have a spreadsheet application that includes many macros, 15 visible sheets, and numerous hidden sheets. I have a macro button on the last sheet that saves a copy of this spreadsheet in the same folder where the main one is located (we call the newly saved copy "Scenario 1.xls"). However...
    • gwest
    • Thread
    • location path same save all sheets values and format
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top