I followed your procedure but with slight changes:
When loading the CSV file, in the left side of the dialog box I checked "decimal separator" and also "thousands separator". In the right side I used "Separator->Semicolon" and I also checked the "Extended number scanning" box as you recommended.
I ...
Search found 5 matches
- Thu Apr 11, 2024 10:11 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Convert numbers stored as text to numbers
- Replies: 2
- Views: 31948
- Mon Apr 08, 2024 1:50 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Convert numbers stored as text to numbers
- Replies: 2
- Views: 31948
Convert numbers stored as text to numbers
Hello,
I'm using data tables extracted from the Statistics Canada website. The download format is in CSV.
I can import the files in Planmaker. The data tables contained in the files appear as a normal spreadsheet data (one number in each cell). The columns of numbers displayed look OK but the ...
I'm using data tables extracted from the Statistics Canada website. The download format is in CSV.
I can import the files in Planmaker. The data tables contained in the files appear as a normal spreadsheet data (one number in each cell). The columns of numbers displayed look OK but the ...
- Fri Jan 05, 2024 6:03 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 301914
Re: Linking data from Spreadsheets
What I meant is that one cannot press = then use the mouse and point/clic directly to a cell in a sheet from another file (to link both cells in a formula) as can be done in Exel and LibreOffice for instance. I couldn't get it to work.
But as you indicate, PlanMaker does allow you to link in its ...
But as you indicate, PlanMaker does allow you to link in its ...
- Thu Jan 04, 2024 8:05 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 301914
Re: Linking data from Spreadsheets
Thank you for your answer and providing a solution.
Are there any intentions in enabling linking two cells from sheets in different files using the equal sign as can be done linking two cells from two sheets of a given file ?
-mg
Are there any intentions in enabling linking two cells from sheets in different files using the equal sign as can be done linking two cells from two sheets of a given file ?
-mg
- Thu Jan 04, 2024 3:40 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 301914
Re: Linking data from Spreadsheets
Hello, I have a similar issue trying to link two spreadsheets contained in two different files (tes1.xlsw and test2.xlsw), using Planmaker running in win11.
If the two sheets are within the same file I can link cells from one to the other (say in a formula). However, if the two sheets are in two ...
If the two sheets are within the same file I can link cells from one to the other (say in a formula). However, if the two sheets are in two ...