Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by chrismichalczuk
at 2024-07-24 04:34:02
ModifyPoint:500 Replies:5 POST_ID:829088USER_ID:11989
Topic:
Spreadsheet Software;;Microsoft Excel Spreadsheet Software
I have a CSV which I transfer to exel. I format the column as text but some lines still show as numeric or float - how can I convert these to text as these are telphone numbers
Main Phone
0017 325 486 100
0060 326 879 020
+1300 762 762
1283563357 <------------------------ this shows as a number want this as text
001 843 412 3743
9.66533E+11 <------------------- this shows as a float want this as text (966532709562 which shows in the formula bar)
1253675695 <------------------------ this shows as a number
Main Phone
0017 325 486 100
0060 326 879 020
+1300 762 762
1283563357 <------------------------ this shows as a number want this as text
001 843 412 3743
9.66533E+11 <------------------- this shows as a float want this as text (966532709562 which shows in the formula bar)
1253675695 <------------------------ this shows as a number
Author: chrismichalczuk replied at 2024-07-24 06:54:19
you are a star !
Accepted Solution
Expert: johnb25 replied at 2024-07-24 06:01:33
500 points EXCELLENT
If you select the column/range with the phone numbers, and do Data/Text to Columns from the ribbon.
Select Fixed Width, and then chose Text as the Column Data Format.
John
Select Fixed Width, and then chose Text as the Column Data Format.
John
Author: chrismichalczuk replied at 2024-07-24 05:45:42
is there no other way to convert this - I have used the format cell as text type but it ignores these specifics as if it doesnt understand how to convert to text !
Expert: johnb25 replied at 2024-07-24 05:01:30
Alternatively, you can try to change the file extension to .txt before opening it, and in the Text Import wizard, specify that column as being a Text column.
John
John
Expert: duncanb7 replied at 2024-07-24 04:40:02
You can change cell format by select a cells or drag many cells and right-click it and click "format cell" from which there is a lot option you can choose for any different number, date ,format,etc ..
If it is not completely to meet your need, you need to do it on VBA
Duncan
If it is not completely to meet your need, you need to do it on VBA
Duncan
