Share via

Need to keep leading zero's when saving to .CSV in Microsoft 365 MSO

Anonymous
2021-04-30T18:14:19+00:00

I am using Microsoft Excel for Microsoft 365 MSO and have a list of part numbers that are numbers stored as text with leading zeros.  When I save as .CSV for file import, the leading zeros disappear.  I need the .CSV file to retain the leading zeros.  I have tried reformatting as text with no success.  I have tried using the Convert Text to Columns Wizard with no success. I tried formula =LEFT(A2,LEN(A2)) and it worked until I need to copy and paste values, then it pastes it as Number stored as Text. Please help me figure this out.

Microsoft 365 and Office | Excel | For home | 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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-01T02:51:17+00:00

    To:  Rohn007

    I use the single apostrophe to convert numbers and dates to text.
    Dates are treated slightly different from numbers but the " ' " is still used.

    Using spaces might be a  faster conversion, but one still has to check the number length and

    skip removal if it exceeds the max number length.

    The link works in both FireFox and Edge for me???

    Maybe I will take up golf.

    [Edit]
    This new link may work reliably...

    https://1drv.ms/u/s!Au8Lyt79SOuhiXoNjAh-\_-zLi49O

    Thanks again.

    NLtL

    0 comments
  2. Anonymous
    2021-05-01T03:46:44+00:00

    The link works in both FireFox and Edge for me???

    Maybe I will take up golf.

    Thanks again.

    NLtL

    I'm thinking I'll take up tiddly winks again.  Golf is too strenuous. 

    I'm going to blame the discrepancy on the "pink moon". 

    That's my story and I'm sticking by it ... <sigh>

    0 comments