Category:

Posted on by

Opening a csv file in Excel. How to keep all leading zeros in fields

When you open a csv file in Excel, if you have data that contains zero (0) at the beginning, it will be transformed into numbers losing the leading zero. Let’s see how to avoid losing the leading zeros.

Do not open the csv file with Excel. Instead, open Excel with a new sheet. Go to the “Data” tab and press “from text / csv”.

Upload your csv file now. A new window appears which performs a data transformation.

Above you have some important choices.

Excel figured out which the csv file delimiter is. Note: use this procedure also when you are importing data saved in a csv file with a different delimiter from your standard.

Excel tries to figure out the data type for each column “based on the first 200 rows”; I recommend that you select “based on the entire dataset”. This way Excel should understand that the column with zeros contains text and not numbers. Press “Load” to end the procedure or “Transform Data” to force other choices if necessary.

Posted on by

Set up an Office 365 account on GMail

This article was born from the difficulties encountered in setting up a Microsoft Office 365 mail account on the Gmail mail client on a smartphone. But

Reading Office 365 in Gmail is not recommended.

In the Gmail add account screen, the most obvious attempt is to add the account using “Exchange and Office 365”.

You will see the mailbox added correctly and working but we have encountered problems: in some accounts on Gmail you do not see all the mail folders in the mailbox.

Solution

The solution is to perform an installation in imap.

Install the account using “Other”:

Once you have entered your email account, the “Manual Configuration” button appears.

Push it. The procedure will ask you in sequence:

password
address of the mail arrival server: outlook.office365.com
address of the mail receiving server: smtp.office365.com

The procedure does not require the specification of ports. For the sake of completeness, we recall all the parameters of the Microsoft Office 365 imap and smtp.

IMAP settings – Server name: outlook.office365.com – Port: 993 – Encryption method: SSL

SMTP settings – Server name: smtp.office365.com – Port: 587 – Encryption method: TLS or STARTTLS

Important

By doing this you deactivate the synchronization of address book, calendar and email. To solve it, simply go to the Outlook app, in the account and reactivate the synchronization.

But remember that the best thing for Office365 is to use the Outlook app on smartphones. Reading Office 365 in Gmail is not recommended.

 

Posted on by

Email – how to move your address book from Thunderbird to Outlook

  1. export the Thunderbird address book in .CSV format without special configurations
  2. while importing the .CSV file into Outlook, after choosing the “Contacts” folder in which to import the contacts, click on “Map Custom Fields“, select the fields of the .CSV file and associate them with the fields of the Outlook address book.
Posted on by

Microsoft 365 Business Basic & Microsoft 365 Business Standard

Office

Microsoft 365 Business Basic

  • Email with a 50 GB mailbox .
  • Microsoft Teams.
  • Access web versions of Office apps: Outlook, Word, Excel, PowerPoint, OneNote)
  • 1 TB of OneDrive cloud storage per user.
  • Online meetings and video conferencing for up to 250 users.

Cost : 50,64 euro / year (+ VAT)

Microsoft 365 Business Standard

  • Email with a 50 GB mailbox .
  • Microsoft Teams.
  • Access web versions of Office apps: Outlook, Word, Excel, PowerPoint, OneNote
  • 1 TB of OneDrive cloud storage per user.
  • Online meetings and video conferencing for up to 250 users.
  • Desktop versions of Office apps: Outlook, Word, Excel, PowerPoint, OneNote (plus Access and Publisher for PC only – no macOS).
  • Use one license to cover fully installed, Office apps on five mobile devices, five tablets, and five PCs or Macs per user.

Cost : 126,48 euro / year (+ VAT)

Every version is compatible with Windows 10, Windows 8.1, Windows 7 Service Pack 1, and the two most recent versions of macOS. All languages included.

Documents : https://www.microsoft.com/en-us/microsoft-365/business

Posted on by

Outlook – I don’t see emails imported with a .pst file

SCENARIO

You need to move emails from one account or personal folder to a different IMAP account. You are using Outlook. You exported the “source” emails to a pst file and imported the file with Outlook to the “destination” account. Everything seems to have been done correctly because you see the folders of the old emails on the new account, however, inside the folders, you don’t see the emails.

Don’t be alarmed! The emails are there ….. but they are hidden

SOLUTION

In Outlook, click on a folder where you don’t see the content. At the top click on View – Change View. In the window that appears click on “IMAP Messages“. If you have many folders in the same window,  you have the “Apply current view to other mail folders” button.

Posted on by

Microsoft 365 – Your organization needs more information to keep your account secure

SCENARIO

In microsoft 365 (Office 365) tenant you have disabled multi factor authentication method but alle users receive “Your organization needs more information to keep your account secure” when logon.

SOLUTION

Azure Active Directory > Properties
Manage security defaults
set Enable security defaults to No