cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Version numbers with colon instead of decimal

Hi,

I've having an issue with some version numbers which contain colons instead of a decimal.  These are causing issues as we currently have to download in CSV format (XLSXdownload issue on our side not Flexera).  When opening the files in Excel, because of the colon its converting all of these into time format instead of a decimal.  I ran a quick report with just Product Name and Product Version in and there are 243 products which have the issue - does anyone know if this is by design or if its an oversight which should be corrected?

Thanks

Andy

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

2 Replies
kclausen
Level 15 Flexeran
Level 15 Flexeran

If you need to open these files and edit them, then I would recommend that you edit them with a text editor such as Windows NotePad, or a freeware tool such as NotePad++ instead of using Excel.

0 Kudos
ChrisG
Community Manager Community Manager
Community Manager

You have accurately described how Excel works with CSV files if you open them using a simple double-click. Excel will typically look at the first rows of data in the file and attempt to make a guess at the data type for each column based on the syntax of the data found.

If you want to take more control over how Excel opens CSV files, one way is to proceed as follows:

  1. Ensure the CSV file has an extension of ".txt" (not ".csv").

  2. Use the Excel File > Open menu option to open the file. This should open a text import wizard.

  3. At step 3 of the wizard you can select the data format for each column. Select all columns where you want values to be treated as plain text, and select the Text format option:
    image.png
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
0 Kudos