Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format
Sometimes I run into the problem of a cell with many items in it. For example:
=6546456.23+6548985.89+7892598.25+12548868.32 The cell show the total but if someone is reading the numbers it makes it a more difficult that they are not formatedd with commas. Is there a way to help this visual? Thank you, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format
I don't think there is a "format" that will do what you want, but I would
guess VB could help out... however, we would need to know a little more about your requirements. Are we talking only about addition (and I assume subtraction)? What about multiplication, division and raising to powers? Could any function calls be involved (MOD, SIN, and the like)? I would think the more of these that are involved, the lengthier the code would be to handle them all. -- Rick (MVP - Excel) "Steven" wrote in message ... Sometimes I run into the problem of a cell with many items in it. For example: =6546456.23+6548985.89+7892598.25+12548868.32 The cell show the total but if someone is reading the numbers it makes it a more difficult that they are not formatedd with commas. Is there a way to help this visual? Thank you, Steven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format
Rick,
Thank you for the response. I thought maybe there is a custom routine I am missing. Basically I was thinking for any function that has hardcoded numbers. Using my example I would see at the click of a button: =6,546,456.23+6,548,985.89+7,892,598.25+1,2548,868 .32 I would not be concerned about () on the negatives. I just want to more clearly see the numbers. This does not happen that often but when it does it would be nice to have. Thank you, Steven "Rick Rothstein" wrote: I don't think there is a "format" that will do what you want, but I would guess VB could help out... however, we would need to know a little more about your requirements. Are we talking only about addition (and I assume subtraction)? What about multiplication, division and raising to powers? Could any function calls be involved (MOD, SIN, and the like)? I would think the more of these that are involved, the lengthier the code would be to handle them all. -- Rick (MVP - Excel) "Steven" wrote in message ... Sometimes I run into the problem of a cell with many items in it. For example: =6546456.23+6548985.89+7892598.25+12548868.32 The cell show the total but if someone is reading the numbers it makes it a more difficult that they are not formatedd with commas. Is there a way to help this visual? Thank you, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |