Results 1 to 7 of 7

Set cell to long number value without rounding

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2017
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    15

    Set cell to long number value without rounding

    Hi,

    I'm sure I'm just missing something obvious but I have a raw data set, which I'm putting into a dictionary.

    One of the values is an ID, which can (but not always) be a 20 digit number.

    I've got it into the dictionary by defining the item as variant, and it's being stored as "Variant/String" and it stored in the dictionary without rounding - which is perfect.

    However I'm then trying to get those values into the spreadsheet, by looping through the dictionary and setting certain cells equal to certain values, but every time I try to put this ID into Excel, it rounds after 10 digits.

    Can someone please help?

    I'm trying:

    Cells([row],[column]) = DictionaryEntry.ID

    And I'm totally lost.

    Thanks in advance!

    ---------

    Edit: Probably not the smartest solution but I just went in a formatted the relevant columns a text field prior to putting the values in. Thanks for everyone's help
    Last edited by AB91; 12-23-2018 at 09:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rounding up a cell to a whole number
    By bjkh1508 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2016, 11:07 AM
  2. [SOLVED] Cell with text and number, not rounding to closest full number
    By cblp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2014, 07:51 PM
  3. [SOLVED] How to stop Long numbers from auto rounding...
    By Hogrider in forum Excel General
    Replies: 5
    Last Post: 01-27-2014, 08:34 PM
  4. [SOLVED] Rounding long formula to digit above 0
    By justtune in forum Excel General
    Replies: 15
    Last Post: 09-05-2012, 08:21 PM
  5. Timing how long a number in a cell remains above a certain value?
    By emilehalpin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:18 AM
  6. Rounding a number up in a cell
    By KoolKat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2009, 09:42 PM
  7. Replies: 5
    Last Post: 07-17-2006, 04:39 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1