Thread
:
Printing on notepad from excel worksheet... Please Help!!
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Printing on notepad from excel worksheet... Please Help!!
Does 78E-02 represent a number? If yes, then specify the format you want to
use.
Print #FileNum, "Speed of car A ="; Format(VarA, "00E-00")
or
Print #FileNum, "Speed of car A ="; Format(VarA, "0.00")
wrote:
Hi all,
Is there a way to print a number from excel sheet to notepad file and
not changing the format. For example when I try to print 78E-02 on the
notepad, it prints 0.78.
Secondly, while printing in notepad from
VB
(excel) for instance -
Print # 1 "Speed of car A ="; VarA
It leaves a blank after = sign.
Print results
Speed of car A = 250
Is there a way of printing the value of the variable without the
space??
Your help will be really appreciated.
Thanks,
Riggi
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson