[mso] The fraction format works in my Excel 2000 : Pasting data into excel,problem
- From: Jacques De Schryver <jds@xxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 16 Jan 2003 00:16:50 +0100
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
*************************************************************
Other related posts:
- » [mso] The fraction format works in my Excel 2000 : Pasting data into excel,problem
