LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How to use Decimal data type?

Thanks, Dave!
Wes

On Nov 7, 8:45 am, Dave Peterson wrote:
I'd use:

Dim decX as variant
decx = cdec(someothervariable)

Sun Tzu wrote:

Excel VBA Editor Help says Decimal is a supported data type, but
defining a variable as Decimal does not work.


Dim decX as Decimal


How can I do this? Is there a reference that I need to add?


Thanks,
Wes


--

Dave Peterson




 
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 to type format time in decimal format & calculate time Cheyenne Excel Discussion (Misc queries) 1 February 13th 09 12:09 AM
How to type format time in decimal format & calculate Cheyenne Excel Discussion (Misc queries) 1 February 12th 09 11:54 PM
when I type numbers in a cell it changes it to a decimal point Ton[_2_] Excel Discussion (Misc queries) 4 October 1st 08 09:54 PM
ALL NUMBERS I TYPE HAVE DECIMAL POINT PAPA ROSS Excel Discussion (Misc queries) 3 May 7th 08 09:13 PM
Decimal type in Excel 97 E-Cube Excel Programming 2 November 18th 05 10:22 PM


All times are GMT +1. The time now is 02:16 AM.

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"