How specify number format of cell value in concatenate function?
in [Functions]
|
Prev: how do i set an alarm to work on excel
Next: Worksheets are stuck on default text format with left align
From: R1dgeway on 27 Mar 2010 14:04 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.
From: Dave Peterson on 27 Mar 2010 14:32
="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 |