Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default integer with decimal display

hi community

can someone assist me on this...

i place a value with 3 decimal places, eg: 13.456
and
when i use the the roundup(value,0)
and
the display is 13.0
could this be not right?
and if it is wrong, what is happening to my excel
i am using version 2003

thanks community for the assistance :)
--
oldLearner57
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default integer with decimal display

Hi,

I'm not clear from your post whether you're having this problem in a
worksheet or in VBA code.

If you've declared an integer variable and try to read the value 13.456 into
it, the decimal part will be ignored and only the 13 is stored. Therefore,
when you try to ROUNDUP, it will still return 13.

Entering 13.456 in a worksheet cell then referencing it in a ROUNDUP formula
produces the "correct" result of 14. The ROUND formula will return 13 in this
instance.

Cheers, Pete.

"oldLearner57" wrote:

hi community

can someone assist me on this...

i place a value with 3 decimal places, eg: 13.456
and
when i use the the roundup(value,0)
and
the display is 13.0
could this be not right?
and if it is wrong, what is happening to my excel
i am using version 2003

thanks community for the assistance :)
--
oldLearner57

Reply
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
caused - an integer or decimal number may be required donn Excel Discussion (Misc queries) 3 September 13th 06 11:01 AM
how to split one decimal pt integer off & to next columnin excel? Roger Knights Excel Discussion (Misc queries) 3 October 27th 05 12:10 AM
excel-enter integer number and get two decimal places Jack H Excel Discussion (Misc queries) 2 October 16th 05 10:01 PM
Excel ActiveX Scrollbar - change from integer to decimal Tonette Excel Discussion (Misc queries) 2 October 15th 05 03:41 PM
Numbers display as decimal, i.e. enter 123 display 1.23 IGH219 Setting up and Configuration of Excel 1 June 16th 05 09:16 PM


All times are GMT +1. The time now is 09:49 AM.

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

About Us

"It's about Microsoft Excel"