leading numbers

Sabrain ✭✭✭
edited 02/19/24 in Smartsheet Basics

I have a cell where different numbers are always entered. Most of the time, this field contains a leading 0. With a leading 0, the text is left-aligned, but with any other leading number, the text is right-aligned. I have a formula where this cell should be compared to another cell. However, this no longer works when the text is right-aligned. Why is that?

I have also noticed that there is a ' when the text contains a leading 0.