User Posts: Musiha
0
How to Merge and Center Selected Cells in Excel (4 Ways)
0

You may need to use the same values in some cells. In that case, you don’t need to insert the same cell value repeatedly, simply you can merge and center those ...

0
How to Use Implicit Intersection Operator in Excel (4 Examples)
0

Sometimes you may need to use an implicit intersection operator in Excel. In this article, I will show you how, and where to use an implicit intersection (@) ...

0
How to Use IF-THEN Statements with Text in Excel (7 Examples)
0

Sometimes you may need to use some combination of functions in Excel for searching a particular text or returning the answer as text. So, if you are looking ...

0
How to Make Floating Bar Chart in Excel (2 Easy Ways)
0

Sometimes for data visualization, you may need to create a floating bar chart in Excel. So, if you are looking for how to make this chart in Excel, then you ...

0
How to Create a Date Picker in Excel Using VBA (with Easy Steps)
0

A date picker is one kind of dynamic calendar that allows the user to select a particular date. So, if you are looking for how to create a date picker with the ...

0
How to Shade Area Between Two Lines in a Chart in Excel 
0

To increase the visuality of a data range, you may need to shade the area between two lines of an Excel chart. So, if you are looking for how to shade the area ...

0
How to Perform Drawing of Objects with VBA in Excel (2 Examples)
0

Sometimes you may need to draw a shape or an object in Excel. So, if you are looking for drawing objects using VBA code in Excel, then you have come to the ...

0
How to Calculate Volatility for Black Scholes in Excel (2 Methods)
0

Sometimes you may need to calculate volatility using the Black-Scholes formula in Excel. So, if you are looking for how to calculate volatility for the ...

0
How to Perform Scaling for Numbers in Excel (7 Effective Ways)
0

When you have a dataset that contains numbers with more than 4 digits, then you may need to scale them for lowering those digits. So, if you are looking for ...

0
How to Create Project Pipeline in Excel (2 Suitable Methods)
0

Sometimes for business or institute purposes, you may need to create a project pipeline in Excel to track all your projects easily. So, if you are looking for ...

0
How to Find Intersection of Two Trend Lines in Excel (3 Methods)
0

An intercept of two trend lines represents the solution for these equations and you may need to find that point using Excel. So, if you are looking for how to ...

0
How to Join Tables in Excel (6 Suitable Methods)
0

Sometimes you may need to join tables in Excel for passing information. So, if you are looking for how to join tables in Excel then you have come to the right ...

0
How to Create Chart Slider in Excel (2 Suitable Ways)
0

Sometimes for data visualization, you may need to make a chart. Furthermore, a chart slider is a more interesting and useful thing for data visualization. You ...

0
How to Calculate Skewness in Excel (2 Effective Methods)
0

Skewness is a basic statistical concept. Sometimes, you may need to calculate the skewness in Excel. So, if you are looking for how to calculate the skewness ...

0
How to Do Multi Product Break Even Analysis in Excel
0

If you are heading to a new business, then you should know the calculation of the multi-product break-even analysis. So, if you are looking for how to do ...

Browsing All Comments By: Musiha
  1. Hello MP ROY,
    Thank you for your comment. I have tried these codes and they are working perfectly, except the code in Example3. For that particular code, you can use a new workbook. While I was using a new workbook the code has been perfectly worked there. But you have to be careful about the name of worksheet. You have to use exact worksheet number and name in the code.
    Regards,
    Musiha
    Team ExcelDemy

  2. Hello, J KUMAR.
    Thank you for your comment. I have tried the code too and the code is absolutely right and perfectly working. But you are facing problem because most probably your device is running out of virtual memory. So, when you are trying this code in Excel, at that time you should close all other applications. Also, you should use an individual module for this code.

  3. Hello, CHRIS.
    Thank you for your comment. Actually, with the help of method 4, you are converting numbers into text. But when you re-entered any new value then the cell will hold that value excluding the apostrophe. Basically, the past value along with the apostrophe completely had gone away. So, if you want to keep the apostrophe then you should select that cell (containing new value) and run the Macros again. Then, you will see the apostrophe again with the new value.

ExcelDemy
Logo