Share via

Excel Legacy Wizard Web import problem, data formatting

Anonymous
2022-07-21T08:33:28+00:00

Hello,

I have a problem with Excel Legacy Web Import Wizard and data formats. Namely, when imported, values that begins with zero are formatted as number. For example, “001” is imported as number “1”. I must use Legacy Import Wizard because Web site uses Basic authentication. Is there a way to import values as they are formatted on the site?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-07-21T12:12:46+00:00

    Dear Mirko,

    Good day! Thank you for posting your query in our community.

    Per your description, when you import via Excel Legacy Wizard From Web, values that begin with zero are formatted as numbers.

    Based on my research, currently, it is not available now. Because when you import from the wizard, there is no option for you to select the cell type.

    A workaround I can think of is that you could change the type of the cell manually after importing.

    Image

    Thanks for understanding.

    Sincerely,

    Jazlyn | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest