I am attempting to automate some reports that I do in excel by creating a format I can simply copy into word. In the word doc since the numbers are high numbers I translate to a more simplistic form, for example ($14,175,380 would translate into $14.2M). I am using a custom format IN EXCEL ([>=1000000] $#.0,,"M";[<1000000] $#.0,,"M";General) to show this; however, when I try to create the explanation by using a FIXED or TEXT formula it then proceeds to put it back in its regular format ($14,175,380) Can someone please help with this issue?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pulling in a custom format using a fixed or text formula?
- Thread starter K_ellis25
- Start date
