LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default Excel 2007 formatting wont change in column

I have a file that was exported from Quick Books.

One column with numbers will not add because there is a little green
arrow in the upper left of each cell indicating it is formatted as
TEXT. I can select the cell individually and change the format to
general or currency - but I cannot select the entire column and change
it. If I select the entire column, it will only change the first non
numeric cell.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 File Wont open PDFmaker adam_in_utah Setting up and Configuration of Excel 1 March 27th 08 10:24 AM
how do I change column heading in excel (2007) David Excel Discussion (Misc queries) 5 June 6th 07 05:29 AM
Small game wont work in Excel 2007 Phil Excel Discussion (Misc queries) 4 April 3rd 07 10:24 AM
Date format from excel to CVS file wont. Change in CVS wont stay. Fish''s Mermaid Excel Worksheet Functions 1 October 14th 06 12:28 AM
Date Wont Change in Excel??! [email protected] Excel Worksheet Functions 1 September 18th 06 07:46 AM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"