Thread: Add Decimal Point To Existing Number - Excel Help Forum

Home » Add Decimal Excel Formula » Thread: Add Decimal Point To Existing Number - Excel Help Forum

Maybe your like

Excel Help Forum
  • Register
  • Help
  • Forgotten Your Password?
  • Username Password Remember Me?
Excel Help Forum
  • Advanced Search
  • Home
  • Forum
  • Microsoft Office Application Help - Excel Help forum
  • Excel General
  • Add decimal point to existing number
+ Reply to Thread Results 1 to 3 of 3 Add decimal point to existing number
  • LinkBack
    • LinkBack URL LinkBack URL
    • About LinkBacks About LinkBacks
  • Thread Tools
    • Show Printable Version
    • Subscribe to this Thread…
  • Rate This Thread
    • ‎ Excellent
    • ‎ Good
    • ‎ Average
    • ‎ Bad
    • ‎ Terrible
  • Display
    • Linear Mode
    • Switch to Hybrid Mode
    • Switch to Threaded Mode
  1. 01-17-2009, 04:30 PM #1 KarambaStar
    • View Profile
    • View Forum Posts
    KarambaStar is offline Registered User Join Date 02-14-2008 Posts 8

    Add decimal point to existing number

    I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula? Thanks!
    Last edited by KarambaStar; 01-17-2009 at 04:39 PM.
    Reply With QuoteRegister To Reply
  2. 01-17-2009, 04:33 PM #2 VBA Noob
    • View Profile
    • View Forum Posts
    VBA Noob is offline Forum Contributor VBA Noob's Avatar Join Date 04-25-2006 Location London, England MS-Off Ver xl03 & xl 07(Jan 09) Posts 11,988
    Place 100 in a blank cell > copy the cell > now select the numbers > right click > paste special > divide VBA Noob
    _________________________________________ Credo Elvem ipsum etian vivere _________________________________________ A message for cross posters Please remember to wrap code. Forum Rules Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 01-17-2009, 04:39 PM #3 KarambaStar
    • View Profile
    • View Forum Posts
    KarambaStar is offline Registered User Join Date 02-14-2008 Posts 8
    You...are...super...awesome. Worked great! Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread « Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Bookmarks

Bookmarks
  • Submit to Digg Digg
  • Submit to del.icio.us del.icio.us
  • Submit to StumbleUpon StumbleUpon
  • Submit to Google Google

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  • BB code is On
  • Smilies are On
  • [IMG] code is Off
  • HTML code is Off
  • Trackbacks are Off
  • Pingbacks are Off
  • Refbacks are Off

Forum Rules

-- vB4 Default Style -- Mobile Style Premium -- Lightweight -- Fully Optimized -- Mobile_V1 All times are GMT -4. The time now is 08:03 PM. Search Engine Friendly URLs by vBSEO 3.6.0 RC 1

Tag » Add Decimal Excel Formula