ExcelBanter - how do you use the text function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do you use the text function? (https://www.excelbanter.com/excel-worksheet-functions/31466-how-do-you-use-text-function.html)

bird_62

how do you use the text function?

When using the text function =text(value,format_text), where can i find the
possible format_text options?

Mike Middleton

bird_62 -

When using the text function =text(value,format_text), where can i find
the possible format_text options? <

Some of them show up if you search built-in Help for "number format codes,"
or choose Format | Cells | Number | Custom.

- Mike
www.mikemiddleton.com

All times are GMT +1. The time now is 02:10 AM.