Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
View formats of columns
Currently using Excel version 2002
I have a spreadsheet with a large number of columns with different data formats. Is there a way of viewing the formats for each of the various columns, similiar to the facility of opting to view cells with formulas rather then data? -- James |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
View formats of columns
No simple method with the XL sheet, but you could use some VB to define them.
Selecting some blank cells that contain your formats (presumably a row), you could do this: Sub ListFormats For each c in Selection c.value = c.NumberFormat Next End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James C" wrote: Currently using Excel version 2002 I have a spreadsheet with a large number of columns with different data formats. Is there a way of viewing the formats for each of the various columns, similiar to the facility of opting to view cells with formulas rather then data? -- James |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
View formats of columns
Thanks Luke this helped
-- James "Luke M" wrote: No simple method with the XL sheet, but you could use some VB to define them. Selecting some blank cells that contain your formats (presumably a row), you could do this: Sub ListFormats For each c in Selection c.value = c.NumberFormat Next End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James C" wrote: Currently using Excel version 2002 I have a spreadsheet with a large number of columns with different data formats. Is there a way of viewing the formats for each of the various columns, similiar to the facility of opting to view cells with formulas rather then data? -- James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Columns in split view | Excel Worksheet Functions | |||
Can I save formats like hidden columns... | New Users to Excel | |||
Can you view cell formats without opening the formatting window | Excel Discussion (Misc queries) | |||
User Choosing Which Columns to View | Excel Discussion (Misc queries) | |||
cant view columns ie A B C D.. | New Users to Excel |