Imported data will not format

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Could you give a little bit more information?

What type of data are you importing?

How are you importing it?

Where are you importing it from?
 
Upvote 0
Welcome to the Board!

A lot of times imported data can be recognized as text. If you highlight the column(s) in questions and goto Format-->Cells-->Apply your format, then goto Data-->Text to Columns-->Finish it will apply that format.

Hope that helps,

Smitty
 
Upvote 0
Excel file is sent to me with data ( numbers ) pulled from "other" data sources. I am to format the data using the currency format and then crunch the numbers several ways. Usually I use the Data | Text To Columns tool to get the data to respond. This time - no workee.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Macro to import multile xml into xlsm with Map data properties or schema
Replies
5
Views
99
Kerryx
K
B
  • Question
Number format with 6 digits from import without leading zeros
Replies
4
Views
525
bkeebaugh
B
R
  • Solved
Power Query and cell formatting
2
Replies
10
Views
272
Peter_SSs
Peter_SSs
C
  • Question
TextToColumns Date Conversion Fails for June, July and September
Replies
7
Views
132
Dave Patton
D
O
  • Question
Converting Time When Formatting Doesn't Work
Replies
1
Views
140
awoohaw
awoohaw

Forum statistics

Threads
1,215,059
Messages
6,122,913
Members
449,093
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top