Support Board

Date/Time: Sun, 06 Oct 2024 10:25:20 +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] Link To Thread - Link To Post [Go To First Post]
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