User Posts: A.N.M. Mohaimen Shanto
0

## How to Merge Cells in Excel with Data (7 Quick Ways)

Certainly, Excel is a popular and useful tool for arranging and manipulating data. Now, combining multiple cells is a common scenario while working with Excel. ...

0

## Copy Worksheet to Another Workbook without Reference in Excel

One of the common scenarios in Excel is to copy an existing sheet and have it on another workbook. However, the problem arises when some formulas are linked ...

0

## How to Merge Rows and Columns in Excel (3 Smart Ways)

One of the most commonly used Excel features is Merge. Merge is combining multiple cells into one cell. The basic Merge option combines multiple cells into ...

0

## How to Perform Conditional Transpose in Excel (2 Easy Examples)

This tutorial shows how we can add conditional transpose in excel. In some situations, you might need to rearrange your rows and columns. If you do it ...

0

## How to Convert Multiple Rows to a Single Column in Excel

We know what rows and columns are in Excel. Basically, data is spread into multiple rows or columns. Now, in this tutorial, we are going to show how you can ...

Browsing All Comments By: A.N.M. Mohaimen Shanto
1. Reply 2. Reply Hello P MUMU,
We are glad to know that this article helped you to solve your problem. For more like this, make sure to check our other articles from ExcelDemy.

3. Reply Hello Polina. Thanks for asking. Basically, you have to change the cell references here.
Suppose you have data in the following ranges:
1. N3:N13
2. P1:P19
3. AB13:AB20
4. CC10:CC20

Just use the following code:

Sub ConvertTextToNumber()
With Range(“N3:N13”)
.NumberFormat = “General”
.Value = .Value
End With

With Range(“P1:P19”)
.NumberFormat = “General”
.Value = .Value
End With

With Range(“AB13:AB20”)
.NumberFormat = “General”
.Value = .Value
End With

With Range(“CC10:CC20”)
.NumberFormat = “General”
.Value = .Value
End With

End Sub

There are various ways. But this is the simplest.

4. Reply Hello HOWARD,
Thanks for asking this important question. Basically scenario summary will show the latest dataset in the current values column. As we changed the scenario by clicking OK.

Now, this is not a wonderful solution. But it may help you.

1. Copy the original dataset to a new sheet.
2. Then go to Scenario Manager
3. Now click Summary.
You will see the original data in Current Values.
Thank You.

5. Reply Hey Luna, you can use VBA codes to solve your problem if these methods don’t work.   