LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by Vsemkoma View Post
I attached a variable source excel sheetbut when I look at my value for my variable, the application adds .0000 to my value.
It does not seem to do it to all, just for some case. long number mostly

I kept it to used the value as text and also tried to used as integer.

ex:
excel
street number
2345
badboys
street number = 2345.0000

why?
К стате пользуюсь очень правдивым гороскопом по крайней мере мне всегда выходит точно м...да грязь,насилие,жестокость.
Try:

=Text(street number's cell,"#")
__________________
Asobi Wa Owari Da
 
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
#DIV/0! errors Erin Leva[_2_] Excel Worksheet Functions 2 May 28th 08 09:44 PM
Excel Throwing Circular Errors When No Errors Exist MDW Excel Worksheet Functions 1 August 10th 06 02:15 PM
#DIV/0! Errors Cindy Excel Worksheet Functions 5 March 30th 06 05:27 PM
Any errors in this?? Frazer Excel Discussion (Misc queries) 0 August 19th 05 08:15 PM
Unresolved Errors in IF Statements - Errors do not show in results Markthepain Excel Worksheet Functions 2 December 3rd 04 08:49 AM


All times are GMT +1. The time now is 03:35 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"