Microsoft Office Forums - View Single Post - changing column formats

Thread: changing column formats

View Single Post

Old

03-30-2010, 08:28 PM

herbycanopy herbycanopy is offline

herbycanopy is offline

herbycanopy uses Windows XP

Windows XP herbycanopy uses Office 2007

herbycanopy uses Office 2007

Office 2007

Novice

The original poster

Join Date: Mar 2010

Posts: 9

herbycanopy is on a distinguished road

Default

changing column formats

For some reason my Excel columns are not abc's now, they are now numbers. This makes cell referances look like this now..

Code:

=SUM(R[-4]C:R[-2]C)

How can I change this back to the old A1 B3 system?

Reply With Quote