That's why I'm still using Visicalc.

MadEngineer: Opening a csv file with a new install of Excel and it prompts me about the different conversions it can run including for large numbers into scientific notation

I click don’t covert.

Large numbers are still in scientific notation

Have you resized the column/s. It could be displaying in scientific notation to fit in the column width. Resizing it could display the large numbers. 

neb:

floydbloke:

Another sob story about travellers not insuring themselves properly, read the policy people!!

https://www.stuff.co.nz/nz-news/350387052/christchurch-woman-indonesian-hospital-after-being-seriously-injured-scooter 

I'm going to dissent here and not join in the victim-blaming: Do you really read and memorise all 124 pages of your insurance policy, and every single time you do anything request full technical details of whatever you're using and then go through the entire lot to check that there isn't some obscure clause or corner case that you might be violating?  This seems like a completely arbitrary cutoff, it doesn't say how the accident occurred but if someone hit them then it wouldn't make any difference whether they were on a 50cc bike/moped, a 125cc bike, or a 1250cc bike.

Senecio:

MadEngineer: Opening a csv file with a new install of Excel and it prompts me about the different conversions it can run including for large numbers into scientific notation

I click don’t covert.

Large numbers are still in scientific notation

Have you resized the column/s. It could be displaying in scientific notation to fit in the column width. Resizing it could display the large numbers. 

MadEngineer:  Opening a csv file with a new install of Excel and it prompts me about the different conversions it can run including for large numbers into scientific notation

I click don’t covert.

Large numbers are still in scientific notation

 

Q: Have you resized the column/s. It could be displaying in scientific notation to fit in the column width. Resizing it could display the large numbers. 
A: Nope/no difference . The numbers are barcodes.

 

@neb 56 pages on our policy. Started to read, convoluted in many parts, got sick of reading so taking a deep breath and a prayer that we won’t need it. 

https://policy.poweredbycovermore.com/nzcm/files/documents/pds/PW_CPC_CBI.pdf

Pac n Save in Petone who conveniently stamp their name in a vertical stripe running strategically over the $ price per Kg on their meats and chickens, like a strike through.

Do they imagine it appears accidental that the stamp is concealing the Kg price and that it’s necessary to have their name printed twice on that small label in case we might not know we are in Pac n Save.  The clue of where we are shopping is already printed at the bottom of the label with Pac n Save in larger heavy bold, so why the extra stripe over the price? 

Is it remotely possible they are trying to dupe the customer. 

This:

Followup in this post.

Eva888:

 

Pac n Save in Petone who conveniently stamp their name in a vertical stripe running strategically over the $ price per Kg on their meats and chickens, like a strike through.

 

Do they imagine it appears accidental that the stamp is concealing the Kg price and that it’s necessary to have their name printed twice on that small label in case we might not know we are in Pac n Save.  The clue of where we are shopping is already printed at the bottom of the label with Pac n Save in larger heavy bold, so why the extra stripe over the price? 

 

Is it remotely possible they are trying to dupe the customer. 

 

Well it seems that they are not required to comply with Comcom until 30 August 2024 a few days from now. Will make sure to shop there after that date.

Worth reading the regs from section 47 

https://comcom.govt.nz/__data/assets/pdf_file/0024/347154/Unit-pricing-regulations-a-guide-for-grocery-retailers-Guideline-March-2024.pdf

47 Unit pricing is intended to help consumers make better informed purchasing decisions.
Therefore, unit pricing should be easy for consumers to notice, read, understand and use.

48 The Regulations require that the unit price must be displayed:
• Clearly and legibly; AND
• In a font size no less than 25% of the font size in which the product’s purchase price is displayed; AND
• Prominently, and in close proximity to the purchase price, so that its connection to the product is clear.

49 Unit pricing should be clearly displayed in a consistent, unambiguous and legible manner – this means it can be easily seen and read by consumers (including those with impaired sight and/or restricted mobility) from normal viewing positions and distances.

@Eva888 Re ^^. This is excellent - I thought it was coming but wasn’t sure when. It’s something I use a lot but it’s hit and miss and I get very anti when it’s not shown.

Our local Woolworths historically hasn’t shown unit pricing on its ‘bulk bin’ products and I have frequently complained about it. Then last week the unit prices showed up. I wasn’t silly enough to think they had listened to me - now realise it was simply because the deadline is coming up.

So the font size no less than 25% of the size of the purchase price is their out. If they make the purchase price smaller, then a quarter of that won’t be legible. Why couldn’t they make it no less than half the size minimum. 

Eva888:

 

So the font size no less than 25% of the size of the purchase price is their out. If they make the purchase price smaller, then a quarter of that won’t be legible. Why couldn’t they make it no less than half the size minimum. 

 

All the bits that then say "clearly and legibly", "readable from normal viewing positions" etc cover that.

eracode:

@Eva888 Re ^^. This is excellent - I thought it was coming but wasn’t sure when. It’s something I use a lot but it’s hit and miss and I get very anti when it’s not shown.

 

Our local Woolworths historically hasn’t shown unit pricing on its ‘bulk bin’ products and I have frequently complained about it. Then last week the unit prices showed up. I wasn’t silly enough to think they had listened to me - now realise it was simply because the deadline is coming up.

geoffwnz:

Eva888:

So the font size no less than 25% of the size of the purchase price is their out. If they make the purchase price smaller, then a quarter of that won’t be legible. Why couldn’t they make it no less than half the size minimum. 

All the bits that then say "clearly and legibly", "readable from normal viewing positions" etc cover that.

evnafets:

 

MadEngineer:  Opening a csv file with a new install of Excel and it prompts me about the different conversions it can run including for large numbers into scientific notation

I click don’t covert.

Large numbers are still in scientific notation

 

Q: Have you resized the column/s. It could be displaying in scientific notation to fit in the column width. Resizing it could display the large numbers. 
A: Nope/no difference . The numbers are barcodes.

 

This link recommends importing the CSV file as raw data into a new Excel spreadsheet rather than opening it directly. 

i.e. Data Ribbon.  "From Text", select "comma" delimited and then configure the columns appropriately.