+ Reply to Thread
Results 1 to 2 of 2

"Format"? Problem with thousand separator

  1. #1
    Registered User
    Join Date
    01-08-2008
    Posts
    1

    "Format"? Problem with thousand separator

    Hello

    When working with large numbers the "thousand separator" doesnt work for the whole number, of example:

    Original Number: 2800000000

    Expected Result: 2.800.000.000

    Result Obtained: 2800000,000.00

    I hope the separator could be a dot but a comma works just fine.

    I am using Office 2007 and the Crystal Ball add-on

    Any ideas on how to make this work?

    Thanks a lot for your help

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi Andres,

    What steps are you taking to format the cells? And are your cells formatted previously as Text, or Number?

    I don't know what the 'Crystal Ball' add-in is, so I can't say if it's related to the format issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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