Results 1 to 4 of 4

[SOLVED] How to convert the Swiss franc to excel readable number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    [SOLVED] How to convert the Swiss franc to excel readable number

    Hello,

    I do not know what I need. We just have a entity set up in Switzerland. The report they sent to us is in Swiss franc. The amount format looks like this: 36'700.38. Excel keeps giving me error. How can I change it into 36,700.38? A formula? Or is there a button in Excel can do the work?

    Thanks in advance for helping.
    Last edited by jackson_hollon; 12-27-2015 at 10:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-16-2015, 09:18 AM
  2. Replies: 3
    Last Post: 10-15-2015, 03:52 PM
  3. [SOLVED] How to convert to a readable table
    By Manena in forum Excel General
    Replies: 7
    Last Post: 09-17-2015, 06:10 PM
  4. Replies: 3
    Last Post: 02-27-2013, 01:54 PM
  5. CSV file not readable in excel
    By sepunx2 in forum Excel General
    Replies: 1
    Last Post: 01-20-2009, 06:38 AM
  6. [SOLVED] how do I convert utc to a readable time format?
    By Jon in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:45 AM
  7. Convert Unix timestamp to Readable Date/time
    By Emily in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2006, 08:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1