How to get data mesh to work with trailing zeros.

StaggsJordan

I am working on a project that has 8 different sheets that I am pulling certain information into a report that I am utilizing for a data mesh. On one of my sheets, some of the milestones have a lot of deliverables that are going up to 7.10, 7.11, etc. I am experiencing an issue with "7.10, 8.10, 8.20, 8.30" because the datamesh is identifying them as duplicates with 7.1, 8.1, 8.2, 8.3. When I double click on "7.10" it displays "7.1". Is there a way to force it to be 7.10 when it is double clicked so it doesn't identify as a duplicate?

Samuel Mueller

@StaggsJordan I don't know your full setup, but put one of these ' in front of 7.10 like '7.10. That will identify the "number" as a string and keep the trailing 0.

Samuel Mueller

@StaggsJordan I don't know your full setup, but put one of these ' in front of 7.10 like '7.10. That will identify the "number" as a string and keep the trailing 0.

StaggsJordan

Thank you @Samuel Mueller. I will give that a try.