Results 1 to 2 of 2
  1. #1

    Member Since
    Jun 01, 2014
    Numbers and Strings
    Hi I am using numbers and i what to use pop-up menu with roughly 3 - 5 prices per pop-up menu. I want to put a description next to the price so i remember what the price refers to. Here is an example

    $15 basic food

    $20 premium food

    The problem i have is when i had text to the description it returns me an error message

    The operator "*" expects a number, but the cell contains a string

    Many thanks

    Danny Kirk

  2. #2

    McBie's Avatar
    Member Since
    Apr 26, 2008
    iPad Pro 12.9 latest iOS
    I think you have to define the cell as " text " to achieve that, but than you may encounter issues when you use the cell for calculation.
    You may need a bit of extra ' spreadsheet magic ' to use the cell for calculation.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Working With ComboBoxes and strings
    By Yodda_Hunter in forum macOS - Development and Darwin
    Replies: 0
    Last Post: 05-05-2014, 05:49 PM
  2. Strings with servers
    By Yodda_Hunter in forum macOS - Development and Darwin
    Replies: 3
    Last Post: 02-07-2014, 02:08 PM
  3. What gauge guitar strings do you use?
    By MartinS in forum Schweb's Lounge
    Replies: 24
    Last Post: 07-06-2007, 11:01 PM
  4. Dialing Strings and Internet Connect
    By feanor in forum macOS - Operating System
    Replies: 1
    Last Post: 10-13-2005, 11:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts