LinkBack URL
About LinkBacks
I have a variable (A) defined and would like to change it's value to Scientific notation.
I can't seem to get this to work.
A = ActiveCell.Value
Now I want to convert this to scientific notation and store it back into variable A
Help!
I have a variable (A) defined and would like to change it's value to Scientific notation.
I can't seem to get this to work.
A = ActiveCell.Value
Now I want to convert this to scientific notation and store it back into variable A
Help!
Variables don't have formats; cells do. Just change the number format of that cell to Scientific.
Entia non sunt multiplicanda sine necessitate
Please Login or Register to view this content.
The problem I am having is I need to convert this number and then write it to a text file.
So I read in the number in the active cell, store it to a variable, then do some math on it, and finaly convert it to Scientific form and write that to a text file.
Any suggestions?
Please Login or Register to view this content.
All I get is a blank output
Replace dblNum with the name of your variable.
Post the code if you still have problems.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks