LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default What the heck is wrong here?

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!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How the heck? Dave Excel Worksheet Functions 6 April 8th 08 03:34 AM
Hide and unhide...what the heck!!?? LeahT Excel Discussion (Misc queries) 6 March 21st 08 02:10 AM
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! Chris Excel Worksheet Functions 10 September 10th 06 02:18 AM
I am stupid and don't know what the heck I am doing wrong on this pivot table!!! [email protected] Excel Programming 5 September 9th 06 11:55 PM
I am stupid and don't know what the heck I am doing wrong on this pivot table [email protected] Excel Discussion (Misc queries) 1 September 9th 06 10:24 PM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"