Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AC: Application Confirmation Codes in Scientific Notation #4458

Open
iph-97 opened this issue Oct 30, 2024 · 0 comments
Open

AC: Application Confirmation Codes in Scientific Notation #4458

iph-97 opened this issue Oct 30, 2024 · 0 comments

Comments

@iph-97
Copy link

iph-97 commented Oct 30, 2024

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant