Solved: Formatting numbers and dates - Page 2

erikfoxcroft · 04-21-2023 08:18 AM

I have a spreadsheet with some numbers which are represented in the sheet, and need to appear as plain integers (12345) and ISO dates (yyyy-mm-dd), but they appear on the app as numbers with separators (12,345) and UK standard dates (dd/mm/yyyy). I have tried a few ways of formatting them in the way I need, but nothing seems to work.

Can someone tell me how to get numbers and dates appearing the way I need them to?

Joseph_Seddik

The only way is to display the date as raw text and format it as you wish using AppSheet's TEXT() function, in a SEPARATE column and ONLY for the purpose of display NOT calculation.

View solution in original post