| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to group an excel sheet
I used the apostrophe so that any leading 0's wouldn't be lost from the policy
number. You can remove it/them if you don't want them. "ielmrani via OfficeKB.com" wrote: The reason I could not format it is because apostrophe got added to the beginning of each number. Dave Peterson wrote: Record a macro when you change the formatting for those fields/columns. Include that at the bottom of your existing macro. And I'd bet you had something (a space character) in that last row. Clean up your data and try again. I made it work except for 2 things. One: [quoted text clipped - 34 lines] Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list sheet 1 - same cell (eg A1) in a group of worksheets sheet | Excel Worksheet Functions | |||
| Sheet Group | Excel Discussion (Misc queries) | |||
| On protected Excel sheet users be able to group/ungroup rows/colum | Excel Worksheet Functions | |||
| how do i save one sheet out of a group | New Users to Excel | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Threaded Mode
