Cell formating and Rolling columns

I

IndianGuru

I have two questions -

(a) How do I format a cell to display a number like *2,50,000.00* an
not 250,000.00 ?

(b) I have 10 columns say F to O, that I use to enter data once
month. However, I do not want to see these columns everyday. Can
*roll these columns* by some means. I do not know VBA or Macros.

All help appreciated
 
B

Bryan Hessey

(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?
 
I

IndianGuru

Thanks.

(a) This worked with ##","##","###.##

(b) I got it working by selecting the columns and then using Data/Group
and Outline/Group

Bryan said:
(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?
Click to expand...
 
B

Bryan Hessey

Good to see, and thanks for the response
Thanks.

(a) This worked with ##","##","###.##

(b) I got it working by selecting the columns and then using Data/Grou
and Outline/Grou
Click to expand...
 
Top