If the formula can be written in the rows left side in green color, to change the row from text mode to number mode without hitting f2 for each row.

[kumartrp]

Sir our software downloads this Excel file from the Income Tax website.

Shares in this sheet are in all text mode to buy sales.

They are in the left of the row that has been shifted to the number mode. The F2 is coming to all the number mode only when the F2 is entered.

Any formula can be written, we are unable to enter the F2 to each row.

How to remove this green color and not hit F2?

 

[p45cal]

On the sheet, manually:
Choose an unimportant cell and make sure it's formatted 'General' (it mustn't be Text)
Put a zero in it.
Copy it with say Ctrl+c
Select the range of cells which have the green triangle in them.
Right-click and choose Paste Special…
In the next dialogue choose as follows:


(in the above there's an arrow pointing to the Formats option; you could choose this if you format that single cell you're copying from with the formats you want the cells you're copying to to take on).
Click OK.
That's it.

 

[p45cal]

Using VBA, select the cells to be converted and run this snippet:

With Selection
    .NumberFormat = "General"
    .Value = .Value
End With

I would have shown where you can include this sort of thing in the existing macros but you've password protected the code.

 

[kumartrp]

good and essay method thank you sir

1st essay to small data

2nd post for huge data very good sir
thank you a lot sir

 

[kumartrp]

Using VBA, select the cells to be converted and run this snippet:

With Selection
    .NumberFormat = "General"
    .Value = .Value
End With

I would have shown where you can include this sort of thing in the existing macros but you've password protected the code.

its our company restriction sir