Formatting Within a Formula

[Guest]

I am using the following formula in a single cell and would like to insert
the following formatting for the dollars: [>999999]$#.0,,"M";$#.0,"K".

="The total shippable as of "&TEXT($B$4,"mmmm d")&" is
"&TEXT($D$13,"$#,.0")&" with a total on order of "&TEXT($D$18,"$#,.0")&". The
percent of total shippable to total on order is "&TEXT($G$21,"#%")&". At this
fill rate, another "&TEXT($G$23,"$#,.0")&" ("&TEXT($G$22,"$#,.0")&" total) in
new orders is needed to reach the "&TEXT($D$19,"$#,.0")&" forecast. Please
move up future orders and work with credit to release shippable holds as soon
as possible. A copy of the shippable hold report is also attached."
Does anyone know how to do this? I keep getting errors.

 

[Guest]

Try this inside the quotes:

[>999999]$#.0,,""M"";$#.0,""K""

.......

of "&TEXT($D$18,"[>999999]$#.0,,""M"";$#.0,""K"" ".The


HTH

 

[Guest]

A couple of missing double-quotes..........
Try this.......

="The total shippable as of "&TEXT($B$4,"mmmm d")&" is"
&TEXT($D$13,"$#,.0")&" with a total on order of "&TEXT($D$18,"$#,.0")&". The
percent of total shippable to total on order is "&TEXT($G$21,"#%")&". At this
fill rate, another "&TEXT($G$23,"$#,.0")&" ("&TEXT($G$22,"$#,.0")&" total) in
new orders is needed to reach the "&TEXT($D$19,"$#,.0")&" forecast. Please
move up future orders and work with credit to release shippable holds as soon
as possible. A copy of the shippable hold report is also attached."

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Sorry, I mis-read the post.........ignore my previous.

Vaya con Dios,
Chuck, CABGx3

A couple of missing double-quotes..........
Try this.......

="The total shippable as of "&TEXT($B$4,"mmmm d")&" is"
&TEXT($D$13,"$#,.0")&" with a total on order of "&TEXT($D$18,"$#,.0")&". The
percent of total shippable to total on order is "&TEXT($G$21,"#%")&". At this
fill rate, another "&TEXT($G$23,"$#,.0")&" ("&TEXT($G$22,"$#,.0")&" total) in
new orders is needed to reach the "&TEXT($D$19,"$#,.0")&" forecast. Please
move up future orders and work with credit to release shippable holds as soon
as possible. A copy of the shippable hold report is also attached."

Vaya con Dios,
Chuck, CABGx3

I am using the following formula in a single cell and would like to insert
the following formatting for the dollars: [>999999]$#.0,,"M";$#.0,"K".

="The total shippable as of "&TEXT($B$4,"mmmm d")&" is
"&TEXT($D$13,"$#,.0")&" with a total on order of "&TEXT($D$18,"$#,.0")&". The
percent of total shippable to total on order is "&TEXT($G$21,"#%")&". At this
fill rate, another "&TEXT($G$23,"$#,.0")&" ("&TEXT($G$22,"$#,.0")&" total) in
new orders is needed to reach the "&TEXT($D$19,"$#,.0")&" forecast. Please
move up future orders and work with credit to release shippable holds as soon
as possible. A copy of the shippable hold report is also attached."
Does anyone know how to do this? I keep getting errors.

 

[Guest]

Perfect! Thank you for your help.
--

Rob

Try this inside the quotes:

[>999999]$#.0,,""M"";$#.0,""K""

......

of "&TEXT($D$18,"[>999999]$#.0,,""M"";$#.0,""K"" ".The


HTH

I am using the following formula in a single cell and would like to insert
the following formatting for the dollars: [>999999]$#.0,,"M";$#.0,"K".

="The total shippable as of "&TEXT($B$4,"mmmm d")&" is
"&TEXT($D$13,"$#,.0")&" with a total on order of "&TEXT($D$18,"$#,.0")&". The
percent of total shippable to total on order is "&TEXT($G$21,"#%")&". At this
fill rate, another "&TEXT($G$23,"$#,.0")&" ("&TEXT($G$22,"$#,.0")&" total) in
new orders is needed to reach the "&TEXT($D$19,"$#,.0")&" forecast. Please
move up future orders and work with credit to release shippable holds as soon
as possible. A copy of the shippable hold report is also attached."
Does anyone know how to do this? I keep getting errors.