
google.com
https://support.google.com/docs/answer/3094139?hl=…
TEXT - Google Docs Editors Help
Sample Usage TEXT(1.23,"$0.00") TEXT(A2,"#.###") TEXT(24,"#.0?") TEXT(DATE(1969,7,20),"yyyy-MM") Syntax TEXT(number, format) number - The number, date, or time to format. format - The pattern by which to format the number, enclosed in quotation marks. 0 forces display of zeros if a number has fewer digits than the format specifies. For example, TEXT(12.3,"000.00") produces 012.30. Numbers ...