Why is my sheet adding extra characters?

I have a very simple sheet that is used to log activity for an after-action report. The form that employees fill out has a simple, number-validated field to enter start time. They are asked to enter time in 24-hour format with digits only (ie. 2315 or 0800). The sheet is automatically appending a "d" to the end of the number (making it 2315d or 0800d). If I add a new row or change an existing row and use traditional time format (08:00) or any combination of characters that includes more than just numbers, it doesn't happen. It also only happens in the start time column. The end time column doesn't do that.

I'm sure I can fix the issue by creating a new column and deleting the original. I'll do that for now, but to avoid a similar issue in the future, does anyone know why this happens?

Find more posts tagged with

Accepted answers

KPH

Is the column with the start date in formatted as a Duration column type? The d will be added to a number to indicate a duration in days (and it won't be added if the content of the cell is not just numbers as that isn't valid).

You can find the column type by clicking on the column heading:

If you change it from Duration to Text/Number the data entered will be treated as text/numbers and no "d" added.

All comments

KPH

You can find the column type by clicking on the column heading:

If you change it from Duration to Text/Number the data entered will be treated as text/numbers and no "d" added.

RBro79

That was it! Thank you!

KPH

Awesome. Glad I could help.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.