Hi I really needs help
If I use the value 0,292 it transfers the correct value 0,292 but in text format and not in number format.
If I use the value 4,678 it transfers the incorrect value 4 678 without the comma and in number format.
Moderator Note:
Please Login or Register to view this content.
Pls use code tags around your codes.
Last edited by Fotis1991; 06-26-2014 at 04:48 AM.
Try using CDbl:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Hi, I tried it, but the result remains the same
Hi, I tried it and the result was:
If I use 0.262 it shows in the excel cell 0, instead of 0.262
If I use 4.678 it shows in the excel cell 5 instead of 4.678
Is the cell formatted to hide decimal places?
What are your regional settings set to?
Try using Val.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I’m sorry but it’s still not working. What it does, if there is a o before the comma (0.262) it works fine, the moment you use a number with 1 or more before the comma (1.2568 or 4.678) then it move the comma to the back of the number (4 678.0)
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
Hi I attached file, Thanks so much for your willingness to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks