Excel XP Issue Strange 2

[RovirozM]

Hi Guys,

Since sometime ago, I have always an issue with the Excel Format when importing something from other format.

But the thing is this: Did you guys have an issue in the past trying to format a Column that already have values (For example changing the Date Format) and the Excel doesn't change the format? (Visually because internal is done)

My fix is to aply F2 to every Cell to update the format after that change and then automatically the cell changes....

Do you know how can I do a massive Change of that? What is F2?

Thanks!

 

[xlhelp]

The reason it does not change is that Excel is treating your data as text.

Type 1 in a blank cell. Copy it; highlight all cells that do not format; go to Paste Special; select multiply and Click OK.

Now apply your format.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[SkipVought]

Hi,

faq68-5827

You have TEXT, not DATES!

when importing something

I assume that this is a FILE IMPORT. During the IMPORT, you have the opprotunity (ONE TIME) to imput file based on a FIXED file strustrure or DELIMITERS. In step 3, I believe, you can specify the column format for each column defined. One of those formats is DATE, that will MAP your imput TEXT structure to convert to a REAL DATE.

Given that you have this data in the sorksheet, you can COERCE the conversion by one of several means, two if which are:
[tt]
A. Text to Columns Parsing
1) Select the column of data
2) Data > Text to columns --
3) NEXT - NEXT
4) On Step 3 select the proper DATE Conversion
5) FINISH

B. MULTIPLICATION
1) Enter 1 in an empty cell
2) COPY this cell
3) Select the DATA AREA ONLY
4) Edit > Paste Special -- MULTIPLY
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}