Date formatting
Closed
                                    
                        Vikrant Sharma                    
                                    -
                            Oct  2, 2015 at 04:44 PM
                        
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 2, 2015 at 05:25 PM
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 2, 2015 at 05:25 PM
        Related:         
- Date formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- How to change date format in excel - Guide
- Formatting windows 7 - Guide
- How to change date format in openoffice - Guide
1 response
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Oct 2, 2015 at 05:25 PM
    Oct 2, 2015 at 05:25 PM
                        
                    Vikrant Sharma, Good evening. 
Try to do:
Select column with DATES
Format as DATE
Choose one cell, eg. D1 and Type 1 at this cell.
Select D1 and COPY
Select column with DATES
Special Paste --> mark option: Multiply
OK
Is this what you're looking for?
I hope it helps.
            Try to do:
Select column with DATES
Format as DATE
Choose one cell, eg. D1 and Type 1 at this cell.
Select D1 and COPY
Select column with DATES
Special Paste --> mark option: Multiply
OK
Is this what you're looking for?
I hope it helps.
