How specify number format of cell value in concatenate function?
When combining text and cell values in a concatenate function, I would like
to control the number format in the concatenate cell: comma separator, decimal place, etc. |
How specify number format of cell value in concatenate function?
="this is text " & text(a1,"$000,000.00") & " due on: " & text(b1,"mm/dd/yyyy")
R1dgeway wrote: When combining text and cell values in a concatenate function, I would like to control the number format in the concatenate cell: comma separator, decimal place, etc. -- Dave Peterson |
All times are GMT +1. The time now is 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com