You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
we recently got a question from a property manager in AC about applicant confirmation codes being read in Excel as scientific notation. This happens when an id has the letter "E" placed in a position that excel reads as scientific notation, (i.e. "219E01BE" turns into "2.19E+26"), and it renders the confirmation number unreadable. Excel conversions on the spreadsheet don't convert it back to the original number, but they'd turn it into "219,000,000,000,000....". This is a known issue, and typically has been handled manually. However, the number of applications received in AC is making this more difficult to manage. Can we consider omitting the letter "E" from confirmation numbers, or some other intervention to avoid this problem? Low priority, thank you!
The text was updated successfully, but these errors were encountered:
we recently got a question from a property manager in AC about applicant confirmation codes being read in Excel as scientific notation. This happens when an id has the letter "E" placed in a position that excel reads as scientific notation, (i.e. "219E01BE" turns into "2.19E+26"), and it renders the confirmation number unreadable. Excel conversions on the spreadsheet don't convert it back to the original number, but they'd turn it into "219,000,000,000,000....". This is a known issue, and typically has been handled manually. However, the number of applications received in AC is making this more difficult to manage. Can we consider omitting the letter "E" from confirmation numbers, or some other intervention to avoid this problem? Low priority, thank you!
The text was updated successfully, but these errors were encountered: