|
How to keep "1:1" as text
I want to split the text between " : "1:1 起初，神創造天地。" into 2
columns (data - text to columns) at the first SPACE How to format "1:1" to remain as text and not be treated as HH:MM etc. |
How to keep "1:1" as text
In Step 3 of the Text to Columns wizard, in the Data Preview area, click on
the area where it shows 1:1. In Column data format select Text. Then click Finish. -- Biff Microsoft Excel MVP "LiCal" wrote in message ... I want to split the text between " : "1:1 起初，神創造天地。" into 2 columns (data - text to columns) at the first SPACE How to format "1:1" to remain as text and not be treated as HH:MM etc. |
How to keep "1:1" as text
Thanks. But is this the only way?
why setting column 1 (after split, to have 1:1) to text (Format- Cells-Text) prior and after the split operation has no effect? |
How to keep "1:1" as text
If you treat it as a number (not text) at the input stage, then changing the
format to text later will merely display the stored number as text. Times are numbers (as fractions of a day). If you have stored 1:1 as time 01:01, it will be displayed as 0.042361111 if you change it to text. -- David Biddulph "LiCal" wrote in message ... Thanks. But is this the only way? why setting column 1 (after split, to have 1:1) to text (Format- Cells-Text) prior and after the split operation has no effect? |
| All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com