I just tried this, formatting the column before I did the paste of the data, and it still converts to the date. -----Original Message----- From: Jacques De Schryver [mailto:jds@xxxxxxx] Sent: Wednesday, January 15, 2003 3:17 PM To: mso@xxxxxxxxxxxxx Subject: [mso] The fraction format works in my Excel 2000 : Pasting data into excel, problem Hello, When I try to enter 1/4 with a fraction format, (and not = 1/4) it gives me 0.2 in the formula bar, and keeps 1/4 in the cell. If it doesn't work with you try a macro with val(Range("coordinates"). Greetings from France, Jacques -- Jacques De Schryver http://jdsetls.virtualave.net/ Last photo : http://shuttercity.com/ShowPhoto.cfm?PhotoID=51638 http://membres.lycos.fr/lsteven/ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************