View formats of columns

  • Thread starter Thread starter James C
  • Start date Start date
J

James C

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?
 
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
 
Thanks Luke this helped
--
James


Luke M said:
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!*
Click to expand...
 
Back
Top