Login Page - Create Account

Support Board


Date/Time: Thu, 10 Jul 2025 04:09:58 +0000



Post From: Migrating my old spreadsheets to the new Spreadsheet format: Trying to convert Number to Text i

[2014-12-24 23:10:48]
User641744 - Posts: 4
Thanks, Found it.

But... it isn't handling large number values as expected. Any value 6 digits or larger seems to be rendered in exponential form.

For example, =Text(20141225) is returning "2.01412e07"

Can it just return the straight text ("20141225")?

Thanks