| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Cell formating and Rolling columns
I have two questions - (a) How do I format a cell to display a number like *2,50,000.00* and not 250,000.00 ? (b) I have 10 columns say F to O, that I use to enter data once a month. However, I do not want to see these columns everyday. Can I *roll these columns* by some means. I do not know VBA or Macros. All help appreciated. -- IndianGuru ------------------------------------------------------------------------ IndianGuru's Profile: http://www.excelforum.com/member.php...o&userid=27382 View this thread: http://www.excelforum.com/showthread...hreadid=469740 |
|
#2
|
|||
|
|||
|
(a) set the Custom format for the cell to ###","###","##","###.## (b) Without using a VBA-Button, you can select the columns and Hide them, and select the columns either side and Unhide when you wish to enter data. Is that what you mean? IndianGuru Wrote: I have two questions - (a) How do I format a cell to display a number like *2,50,000.00* and not 250,000.00 ? (b) I have 10 columns say F to O, that I use to enter data once a month. However, I do not want to see these columns everyday. Can I *roll these columns* by some means. I do not know VBA or Macros. All help appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=469740 |
|
#3
|
|||
|
|||
|
Thanks. (a) This worked with ##","##","###.## (b) I got it working by selecting the columns and then using Data/Group and Outline/Group Bryan Hessey Wrote: (a) set the Custom format for the cell to ###","###","##","###.## (b) Without using a VBA-Button, you can select the columns and Hide them, and select the columns either side and Unhide when you wish to enter data. Is that what you mean? -- IndianGuru ------------------------------------------------------------------------ IndianGuru's Profile: http://www.excelforum.com/member.php...o&userid=27382 View this thread: http://www.excelforum.com/showthread...hreadid=469740 |
|
#4
|
|||
|
|||
|
Good to see, and thanks for the response IndianGuru Wrote: Thanks. (a) This worked with ##","##","###.## (b) I got it working by selecting the columns and then using Data/Group and Outline/Group -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=469740 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
