Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 471
Default Format Issue

I get a lot of files created from an accounting system that formats data as
"General". I want to format those columns that have numbers in them as
numbers. Generally, just clicking the "," icon will format the cells. But
if a cell has the "General" category, clicking the comma does nothing. I
have to change to General first. It is a pain. Does anyone know a quick
work-around?
 
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
Format Issue DS Excel Worksheet Functions 4 October 13th 06 01:20 AM
Format of Cell an Issue John Excel Worksheet Functions 1 July 9th 06 07:12 PM
Conditional Format Issue Darkdrew Excel Worksheet Functions 3 April 13th 06 04:40 PM
# format issue Cip Excel Discussion (Misc queries) 3 March 31st 06 05:49 PM
Date format issue LadyDoe Excel Worksheet Functions 1 November 17th 05 07:54 AM


All times are GMT +1. The time now is 02:15 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"