Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |