Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel dates


  • Please log in to reply
2 replies to this topic

#1 trevorcork

trevorcork

  • Members
  • 345 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Ireland
  • Local time:09:02 PM

Posted 23 July 2015 - 07:57 AM

I have a friend from california he has got office over here in europ but because of work he needs too change his dates in excel too american format how can i do this?


Edited by hamluis, 23 July 2015 - 09:04 AM.
Moved from Win 8 to Business Apps - Hamluis.


BC AdBot (Login to Remove)

 


m

#2 YeahBleeping

YeahBleeping

  • Members
  • 1,258 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:09:02 PM

Posted 23 July 2015 - 09:37 AM

Hopefully this guide will help.



#3 reckonankit

reckonankit

  • Members
  • 86 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:India
  • Local time:07:32 AM

Posted 24 July 2015 - 03:15 AM

you can easily change date format in excel here is the way

    Select the column containing the dates.
    Go to Data and choose Text to Column
    Choose delimited and click next
    Uncheck all delimiters and click next
    Click on date and choose right format for the dates (default DMY):






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users