Automatically change the cell from general to date
Closed
iamdinesh
Posts
69
Registration date
Tuesday December 4, 2012
Status
Member
Last seen
March 9, 2018
-
Updated on Mar 9, 2018 at 05:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 12, 2018 at 01:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 12, 2018 at 01:07 PM
Related:
- Automatically change the cell from general to date
- Transfer data from one excel worksheet to another automatically - Guide
- How to change whatsapp about date - Guide
- Change computer name cmd - Guide
- Facebook date of birth change - Guide
- How to change idm language - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Updated on Mar 12, 2018 at 01:12 PM
Updated on Mar 12, 2018 at 01:12 PM
Hi Deesh,
Have you created the file using your current Excel version or is it an 'old' file that you are now opening with your current Excel version?
Might be a conversion issue. So try to recreate your workbook.
In case that fails. The following code will change all cells to number format with 2 decimals on all sheets upon opening your workbook. First you need to implement the code, save your workbook and then re-open to see the result.
Code needs to be placed under ThisWorkbook:
Hopefully this will solve/help with your unusual query.
Best regards,
Trowa
Have you created the file using your current Excel version or is it an 'old' file that you are now opening with your current Excel version?
Might be a conversion issue. So try to recreate your workbook.
In case that fails. The following code will change all cells to number format with 2 decimals on all sheets upon opening your workbook. First you need to implement the code, save your workbook and then re-open to see the result.
Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In Worksheets
With ws
.Cells.NumberFormat = "0.00"
End With
Next ws
End Sub
Code needs to be placed under ThisWorkbook:
Hopefully this will solve/help with your unusual query.
Best regards,
Trowa
