Introduction

A supplier sends a replacement-parts list. The buyer opens it in Excel, sorts by cabinet section and copies a code into a purchase request. The code started with zeros, but the request no longer does. Everything still looks like an orderly table. The equipment team now has to establish whether the line refers to the same component.

That is a data-preservation question before it is a part-selection question. Microsoft documents that Excel can remove leading zeros, convert large numerical strings to scientific notation and limit numerical precision to 15 significant digits. A part identifier can look numeric without being a quantity you should calculate. This guide explains what a vending buyer should request and verify when a spreadsheet sits between a supplier’s source list and the final order.

Quick Answer

Treat an exact spare-part code as an identifier, and verify the complete character string at the receiving end. Agree which columns must be handled as text before importing or entering data. Compare a sample of leading-zero and long-digit identifiers with the supplier’s authoritative source, then check the actual order deliverable after export or transfer.

Do not assume changing a cell’s appearance restores information already lost. Microsoft says formatting as Text does not change numbers already entered; it affects subsequent entries. If a code may have been altered, return to the authoritative source or ask the supplier to confirm it. Do not reconstruct missing digits from a similar-looking neighbouring part.

Comparison Table

Who Should Buy This

This check is relevant to operators buying replacement components, distributors consolidating supplier parts lists and maintenance managers preparing a first stock order. It is especially useful when several people exchange CSV files or copy numeric-looking identifiers into spreadsheets. It does not require a connected machine or access to payment or customer data.

If your workflow never uses Excel, confirm the behaviour of the tools actually involved instead of assuming Microsoft’s rules apply universally. The procurement requirement remains exact identifier preservation, but the method depends on the receiving application. A machine quotation should identify how the parts information will be delivered and which source controls the code definition.

How We Evaluate Smart Vending Machines

We use public WEIMI listings to identify three different retail-format candidates below. This is a public-listing procurement shortlist, not an independent test or a claim that any candidate includes a particular spare-parts spreadsheet. The listings do not verify the coding scheme, spreadsheet compatibility or replacement stock policy for a quoted machine.

Evaluate the shopping format first, then ask for documentation tied to the quoted configuration. For the parts-data layer, request an example containing representative identifiers and a statement of which fields must remain exact text. A procurement trial can use non-confidential sample codes. Record whether each result came from a public page, a written supplier answer or an observed file check.

Key Buying Factors

Identify the field’s meaning. Quantity, price and identifier columns serve different purposes. An all-digit part code is not automatically a number for arithmetic. Ask the supplier whether leading zeros, letter case, separators or fixed length carry meaning; do not standardise them away without agreement.

Control entry and import before conversion. Microsoft describes using Get & Transform to set individual imported columns to Text. It also documents Automatic Data Conversions controls for specified Microsoft 365 and Excel 2024 versions. Confirm the installed version and the actual workflow rather than promise a universal menu path. This guide does not change any user setting.

Separate appearance from preservation. A custom number format can display leading zeros in a workbook, but Microsoft limits that approach to relevant shorter number codes and a workbook-only situation. A display format should not be the evidence for an identifier that another program will consume.

Check precision as well as zeros. Microsoft states that Excel numbers have a maximum precision of 15 significant digits and recommends text for number codes of 16 digits or more. A longer identifier deserves a text-preservation check even if it has no leading zero. Reformatting an already altered numeric value does not recover the original sequence.

Retain an authoritative comparison point. Keep the supplier-issued source and the revision relevant to your order. When reviewers find a mismatch, flag the affected line and obtain confirmation. Do not quietly add padding based only on expected length; a different code may refer to a different item.

Best Smart Vending Machines

These candidates support a discussion of retail formats and the documentation buyers should request. No public listing cited here establishes exact spare-part codes or guarantees an Excel-ready parts export.

WEIMI WM22 touchscreen snack and drink machine

The listing describes a touchscreen snack-and-drink format with product information or promotional screen content. Consider it for a project built around screen-led selection. Ask the supplier which parts list corresponds to the quoted dispensing and interface configuration, and how the exact identifiers will be delivered. A generic model name should not replace a confirmed component reference.

WEIMI single AI vending fridge

The public page describes an open, select and close shopping journey and cloud-related operation. Consider that retail flow if it suits the intended merchandising plan. For replacement planning, request the applicable service-parts documentation and the owner of code clarification. Do not infer a particular spreadsheet format, database connection or parts availability from the cloud description.

WEIMI dual-cabinet vending machine

The listing presents a portrait menu, a main section and a secondary spiral section. Consider the combined format when reviewing assortment and site requirements. Ask how the delivered sections are identified in the parts documentation. A code that survives spreadsheet transfer still needs to be mapped to the correct section and ordered configuration.

Feature Comparison

These questions belong in a supplier discussion before procurement. They are not advertised capabilities attributed to the products. Obtain a written answer for the configuration being priced; a different model’s sample file is only an illustration.

Cost & ROI Analysis

A small identifier check can be budgeted without inventing a failure rate. Suppose a buyer checks 30 sample codes at an assumed two minutes each. That is 60 minutes. At an assumed internal labour cost of US$42 per hour, the illustrative allowance is US$42. This is a hypothetical planning example, not a product price, supplier charge, measured saving or demonstrated return.

Replace the sample size and timing with your actual list and review process. A sample check can reveal conversion problems but cannot prove every unreviewed line is correct. Separately budget any supplier clarification or full reconciliation that the project requires. Do not estimate the cost of a wrong component without evidence about that particular purchase.

Best Choice by Scenario

One replacement line: compare the exact code in the request with the supplier’s source and get compatibility confirmation. A manual check can be proportionate if the identifier has not passed through an uncontrolled conversion.

A distributor consolidating many lists: define identifier columns and text handling before combining data. Include examples with leading zeros and long digit strings in the review. Preserve the original source for discrepancy resolution.

A CSV handover to another buyer: check how that buyer imports the file. The extension alone does not demonstrate that the receiving spreadsheet will preserve identifiers. Verify the resulting strings and the final issued order.

A code already appears shortened: stop using the uncertain line until it is reconciled with source. The goal is a correct component reference, not a cosmetically padded cell.

Applications

Use the check when preparing initial spare-parts stock, requesting a replacement quotation, reconciling packing information or handing a parts list from procurement to maintenance. It is most valuable at the point where data changes tools or recipients. Keep exact identifiers distinct from descriptive names so a reviewer can verify both without treating them as interchangeable.

A useful check record identifies the source revision, identifier column, import method, representative test strings, observed result and issued file. Include a leading-zero sample and a long-digit sample when those forms exist in the actual supplier data. Synthetic examples should be clearly marked and must never be submitted as genuine replacement codes.

FAQ

Final Recommendation

Choose a machine format for its retail purpose, then make the associated parts information usable for procurement. Ask which source controls the identifiers, which fields require exact text and how the final order will be checked against that source. Keep the original file available for resolving any discrepancy.

A tidy spreadsheet is not enough evidence for an exact replacement reference. Preserve the string before conversion, verify it after transfer and confirm compatibility separately. Microsoft’s documentation explains the software behaviour; only the supplier and actual project records can confirm the codes for your machine.

CTA

Ask WEIMI for a configuration-specific quotation and the applicable service-parts documentation. Describe your planned spreadsheet handover and request clarification of identifier fields that must retain leading zeros or long digit strings. Include the machine configuration and the responsible reviewer so the supplier can address the actual replacement workflow.

Public sources reviewed 17 October 2026: Microsoft: Keeping leading zeros and large numbers; WM22 listing; single AI fridge listing; dual-cabinet listing. No independent product testing or measured SEO outcome.