#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default Import Data

Hi Everyone
I import my bank account information in excel and on top of Char(160) extra
space, I'm
getting some sort of formatting I think.
I type a number 6 and I get 66666666... continuous no end, no matter how
wide is the cell. If I type a letter or text, It does the same, but in the
Formula Bar I only see 1 number, not all cells, some only, could be text,
could be numbers.
I delete with the keyboard botton and retype but doesn't change anything. If
I go to Edit Clear All or Clear Format then it goes.
Does anyone know what this is?
If I do a Clear All or Format, I loose everything.
Regards
John

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default Import Data

Correction:
If I clear "Format" I loose my formatting, the text or numbers stays
Regards
John
"John" wrote in message
...
Hi Everyone
I import my bank account information in excel and on top of Char(160)
extra space, I'm
getting some sort of formatting I think.
I type a number 6 and I get 66666666... continuous no end, no matter how
wide is the cell. If I type a letter or text, It does the same, but in the
Formula Bar I only see 1 number, not all cells, some only, could be text,
could be numbers.
I delete with the keyboard botton and retype but doesn't change anything.
If I go to Edit Clear All or Clear Format then it goes.
Does anyone know what this is?
If I do a Clear All or Format, I loose everything.
Regards
John


Reply
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
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Import external data, data includes Excel function allen davidson Excel Worksheet Functions 0 July 4th 08 12:39 PM
Tool bar: Data/Import external data/New database query Daniel Setting up and Configuration of Excel 3 February 28th 08 08:40 AM
Prevent equation from skipping data when referencing import data? lybrt98 Excel Discussion (Misc queries) 0 August 30th 05 05:01 PM
how to Import data in excel office2003 with data more 65000 rows Abhijit Excel Worksheet Functions 1 May 13th 05 05:12 AM


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