Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number to text problem
excel newbie here. I was able to cut & paste tabular data from the web to an excel sheet. Each column under its own letter. Looks great. But one of the columns has data that has this format 32:31:00 I want this treated as text particularly when I import into an Access DB. But when I do format|cell|text it changes the contents to 1.354861111 rather than displaying 32:31:00. What I import this into Access DB it brings along this wierd 1.354861111 instead of 32:31:00. Note: when the cell is displaying 32:31:00 and if I click on it it changes to 1/1/1900 8:31:00 AM This is what Access DB sees. Don't want that. Want to see: 32:31:00. Actually 32:31, that is drop of the trailing zeroes. If I leave it as excel formatted it then Access treats it as some date/time field although the Access field is defined as text. Another column has data that looks like 7:02 or 24:02 I want this to be treated as text. Although it does represent mm:ss in this case. -- GottaRun ------------------------------------------------------------------------ GottaRun's Profile: http://www.excelforum.com/member.php...o&userid=31297 View this thread: http://www.excelforum.com/showthread...hreadid=509696 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number to text problem
Use a help column and this formula (time data supposed to be in E10):
=TEXT(E10;"hh:mm") copy down as required Then copy the help column and paste--special--values over your original column and then delete the help column. Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
number to text problem
Don't understand Hans. I got it to work by exporting from excel to a tab-delimited .txt file and then impoting the text file into Access. Worked great. -- GottaRun ------------------------------------------------------------------------ GottaRun's Profile: http://www.excelforum.com/member.php...o&userid=31297 View this thread: http://www.excelforum.com/showthread...hreadid=509696 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |