• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Rep: Simple multiplication going bizarre
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Rep: Simple multiplication going bizarre


  • Subject: Rep: Simple multiplication going bizarre
  • From: Yvan KOENIG <email@hidden>
  • Date: Thu, 29 Apr 2010 17:15:08 +0200

Le 29 avr. 2010 à 16:42, Richard Lake a écrit :

Not really.... instead of sarcasm, please provide an answer as its obvious what I want to do.

Say I take 50000 apples sell them at £1.25 each, I want to be able to show the total as £62,500 not 6.25E+4.

As far as I know, you didn't wrote what you where trying to achieve with this kind of value.

If you want to make other calculations, what you get is perfectly accurate and usable.

If you want to display it from AppleScript, other posted good tips.

If you want to insert the result in a spreadsheet, what you get may be usable too.

Here is an example :

set nn to 4999.0 * 12.5
set nn to nn as string
tell application "Numbers" to tell document 1 to tell sheet 1 to tell table 1
set {rowNum, colNum} to {3, 5}
set cellname to (get name of cell rowNum of column colNum)
set value of cell cellname to nn
set format of range cellname to number
end tell

So, I think that it was useless "de monter sur vos grands chevaux"

Yvan KOENIG (VALLAURIS, France) jeudi 29 avril 2010 17:12:16



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Prev by Date: Re: Simple multiplication going bizarre
  • Next by Date: Re: Simple multiplication going bizarre
  • Previous by thread: Re: Simple multiplication going bizarre
  • Next by thread: FileMaker Pro 10 Insert Picture-Not Links
  • Index(es):
    • Date
    • Thread