| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show format in formula bar
Hello:
On some spreadsheets I have #'s in the billions added together in cells. Sometimes it is difficult to verify the number is 10,000,000,000 because it shows up as 10000000000. My eyes get crossed counting the zeros. I'd love if the formula bar would show 10,000,000,000; however, can't seem to find a way to do this. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show format in formula bar
No, you can't change the number formatting in the formula bar.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Native" wrote in message oups.com... Hello: On some spreadsheets I have #'s in the billions added together in cells. Sometimes it is difficult to verify the number is 10,000,000,000 because it shows up as 10000000000. My eyes get crossed counting the zeros. I'd love if the formula bar would show 10,000,000,000; however, can't seem to find a way to do this. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Some formula results will not show up in the cell | Excel Worksheet Functions | |||
| How do I get the formula to show the result on the worksheet? | Excel Discussion (Misc queries) | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
