S
Shaka215
Gary,
Your code allowed me to insert the "." (PERIOD) but as soon as I tried
to add another character into the cell it always kept the "." (PERIOD)
at the end versus keeping it in its original placement location. Any
ideas? I'm pulling my hair out on this one... Please keep in mind this
is a spreadsheet inside of a VBA User Form so its a bit diffrent then
it being a normal spreadsheet. Any help is much appreciated...I am
woundering if maybe someone could help with a code to make the "." be
instered as text instead of a trigger for 0.00 number format?
==== ORIGINAL MESSAGE ====
From: (e-mail address removed) - view profile
Date: Fri, Jan 5 2007 11:41 am
Email: (e-mail address removed)
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author
Hey,
CALC.ActiveCell.Formula = CALC.ActiveCell.Value & "."
This code above does not allow me to properly insert a "." (PERIOD)
after the ActiveCell.Value. The code works fine when there is nothing
in cell and when its not strictly a number. The following formats work
correctly...
ABC123.01
--123.01
"His tempature was 95.6"
etc...
But when the cell contains strickly numbers like 123 it doesn't want to
insert it. Something to keep in mind is the fact that CALC is a
userform with a spreadsheet plug-in feild (a spreadsheet within in a
user form). All I want is for the ActiveCell.Value to stay put and have
a "." (PERIOD) after the ActiveCell.Value. Any ideas? I been trying all
sorts of things but Excel doesn't seem to want to cooperate. Any help
is much appreciated!!
Reply »
From: Gary''s Student - view profile
Date: Fri, Jan 5 2007 11:51 am
Email: Gary''s Student <[email protected]>
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
CALC.ActiveCell.Value = CALC.ActiveCell.Value & "."
--
Gary's Student
- Hide quoted text -
- Show quoted text -
From: Alok - view profile
Date: Fri, Jan 5 2007 11:56 am
Email: Alok <[email protected]>
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
What excel displays depends on the numeric format. You can type in
10.2222
but if numeric format is set to display only one decimal place it will
display 10.2
If you want a number to display as 10. then change the cell formatting
to
"##."
- Hide quoted text -
- Show quoted text -
Your code allowed me to insert the "." (PERIOD) but as soon as I tried
to add another character into the cell it always kept the "." (PERIOD)
at the end versus keeping it in its original placement location. Any
ideas? I'm pulling my hair out on this one... Please keep in mind this
is a spreadsheet inside of a VBA User Form so its a bit diffrent then
it being a normal spreadsheet. Any help is much appreciated...I am
woundering if maybe someone could help with a code to make the "." be
instered as text instead of a trigger for 0.00 number format?
==== ORIGINAL MESSAGE ====
From: (e-mail address removed) - view profile
Date: Fri, Jan 5 2007 11:41 am
Email: (e-mail address removed)
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author
Hey,
CALC.ActiveCell.Formula = CALC.ActiveCell.Value & "."
This code above does not allow me to properly insert a "." (PERIOD)
after the ActiveCell.Value. The code works fine when there is nothing
in cell and when its not strictly a number. The following formats work
correctly...
ABC123.01
--123.01
"His tempature was 95.6"
etc...
But when the cell contains strickly numbers like 123 it doesn't want to
insert it. Something to keep in mind is the fact that CALC is a
userform with a spreadsheet plug-in feild (a spreadsheet within in a
user form). All I want is for the ActiveCell.Value to stay put and have
a "." (PERIOD) after the ActiveCell.Value. Any ideas? I been trying all
sorts of things but Excel doesn't seem to want to cooperate. Any help
is much appreciated!!
Reply »
From: Gary''s Student - view profile
Date: Fri, Jan 5 2007 11:51 am
Email: Gary''s Student <[email protected]>
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
CALC.ActiveCell.Value = CALC.ActiveCell.Value & "."
--
Gary's Student
- Hide quoted text -
- Show quoted text -
From: Alok - view profile
Date: Fri, Jan 5 2007 11:56 am
Email: Alok <[email protected]>
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
What excel displays depends on the numeric format. You can type in
10.2222
but if numeric format is set to display only one decimal place it will
display 10.2
If you want a number to display as 10. then change the cell formatting
to
"##."
- Hide quoted text -
- Show quoted text -