Results 1 to 3 of 3

Custom # format that will not convert to scientific notation.

Threaded View

  1. 11-05-2023, 10:08 AM #1
    KenV15
    KenV15 is offline
    Registered User
    Join Date
    08-05-2023
    Location
    USA
    MS-Off Ver
    Office 365 V2401
    Posts
    29

    Custom # format that will not convert to scientific notation.

    Hello

    I have a list of numbers in column A (see attached file) that is formatted as text. If you are using vba code to copy over the numbers, what custom number format would you use to stop excel from converting the numbers to scientific notation.

    .Range("A1:A").NumberFormat = "????"
    Attached Files Attached Files
    Last edited by KenV15; 11-05-2023 at 05:22 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to convert scientific notation to correct text format
    By exceleratevba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2020, 10:55 AM
  2. Custom Formatting Scientific Notation
    By Shardling7 in forum Excel General
    Replies: 3
    Last Post: 12-18-2012, 11:45 PM
  3. Custom Cell Format: Scientific notation, dash for 0 and no alignment specifications
    By lwflip in forum Excel General
    Replies: 1
    Last Post: 10-17-2012, 09:18 AM
  4. Custom Number format to get scientific notation and percent
    By lwflip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2012, 09:53 AM
  5. Convert to Scientific notation
    By fabb2004 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2010, 11:59 AM
  6. Custom format for scientific notation
    By Melinda in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-22-2005, 12:00 PM
  7. convert scientific notation to a number
    By Peter in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1