Why does Smartsheet treat 00 as a text instead of a number?

I ran into this the other day because of mistyping a number. I meant to type in 100 to adjust a number in an other column on the sheet. Instead I typed 00 and instead of adjusting the number from 460 to 560, it appears to have concatenated the 00 and changed the number to 4600. Has anyone ever seen this and is the a fix for this. Screen shot below.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!