Skip to content
No Vape

A decimal comma can change how your quit-record file is read

Preserve the original numeric text and verify decimal and grouping separators before adding imported personal record values.

No Vape · Updated

Weekly planner, phone, and glass of water on a table
Illustrative image · Svitlana / Unsplash

Identify the notation used by the source

A personal worksheet may contain time spent on a chosen activity or another genuinely recorded decimal quantity. The text “1,5” can require a decimal-comma interpretation; a comma elsewhere may separate fields. Do not infer the rule from your computer’s language alone. Check the source labels, settings or explanation and retain units alongside values.

Microsoft’s legacy Text Import Wizard documents separate decimal and thousands separator choices and a preview of imported fields. Its controls are one software example, with availability depending on the version. This is not a claim that No Vape exports files or supports spreadsheet importing, and no paid tool is required for the basic comparison.

Microsoft Support: Text Import Wizard

Compare the raw text with a known intended value

In a fictional record, a person has written an activity duration of one and a half hours as “1,5” in an external file. The intended quantity is known from the source, not guessed from a chart. An import that splits it into two fields or interprets the mark differently has not preserved that meaning, even if the worksheet displays tidy columns.

Inspect the original text, chosen field delimiter, decimal convention and resulting value together. A grouping mark is another independent choice. If the source does not establish what a mark means, keep the value unresolved instead of selecting the interpretation that produces a plausible total. These examples concern notation, not recommended activity duration, puff fractions or nicotine-dose calculations.

Repair interpretation on a copy

Use the genuine import controls available in your software to match the known source convention. Reimport a preserved copy and inspect a small set containing the relevant marks before applying the interpretation more widely. Keep row associations and units intact. Avoid replacing every comma with a period in the raw file, because commas may also belong to labels, quotations or field boundaries.

A number-looking string can also remain text. Check the tool’s supported way to identify the actual stored type before assuming a total includes it. Do not force conversion of codes, identifiers or unknown values merely because they contain digits. Display formatting alone and numerical interpretation are different questions; neither should rewrite the original observation.

Verify the summary only after the values are understood

After a verified interpretation, compare known rows and a small manual calculation with the intended result. Record the convention used and the limits of the check. If another person sends an updated file, its settings may differ; do not silently apply the old interpretation without confirming that it still fits.

An unexplained import total should stay separate from your practical quit review. You can continue a current dated note while the file question is resolved. Correct parsing does not fill missing observations, convert one unit into another or demonstrate a health outcome. The useful endpoint is a traceable value in its original unit, not simply a total that looks encouraging.

Sources and scope

Sources inform the guidance. The worksheets and examples are No Vape editorial suggestions, not tested treatments.

  1. Microsoft Support — Text Import Wizard
  2. No Vape — No Vape — app features and store links

Written with AI assistance and checked against the cited sources. No clinical review is claimed. This guide covers practical planning, not individual medical treatment. How we research and write