Hi,
My spreadsheet is to be imported into a SQL database so the format of cells is critical. I have a quantity of cells with time in them e.g. 07:30, 08:15 etc but when I change the format to "Text" they change to 0.3125, 0.34375 etc
How can I maintain the time format whlst setting the cells to "Text" in order to import the file?
Can anyone help, please?
select the cells which you want to change
Select text to columns under data
select delimited > select next > again select next > select text under column data format > select finish
data>text to columns > delimited > next > next > text >finish
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
To use the TEXT function like that, you need to tell excel how you want the answer to look, so maybe...
=TEXT(cell-ref,"HH:MM AM/PM")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks