| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Within a Formula
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. -- Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Within a Formula
Try this inside the quotes:
[999999]$#.0,,""M"";$#.0,""K"" ....... of "&TEXT($D$18,"[999999]$#.0,,""M"";$#.0,""K"" ".The HTH "Rob" wrote: 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. -- Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Within a Formula
Perfect! Thank you for your help.
-- Rob "Toppers" wrote: Try this inside the quotes: [999999]$#.0,,""M"";$#.0,""K"" ...... of "&TEXT($D$18,"[999999]$#.0,,""M"";$#.0,""K"" ".The HTH "Rob" wrote: 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. -- Rob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Within a Formula
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 "Rob" wrote: 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. -- Rob |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Within a Formula
Sorry, I mis-read the post.........ignore my previous.
Vaya con Dios, Chuck, CABGx3 "CLR" wrote: 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 "Rob" wrote: 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. -- Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell formula or formatting | Excel Worksheet Functions | |||
| Formatting with a Formula | Excel Discussion (Misc queries) | |||
| Conditional Formatting Formula | Excel Worksheet Functions | |||
| Formula / Formatting Help - please!" | Excel Discussion (Misc queries) | |||
| Formatting in the formula bar | Excel Discussion (Misc queries) | |||
Hybrid Mode
