![]() |
what does '- do in a cell?
i'm trying to indicate that there is no relation cost between an origin and a
destination however 0 would not indicate this as zero would indicate that the cost = $0.. what can i put into a cell to let it know that no relation exists when i want to use the solver tool? also, what exactly does '- mean in a cell? |
what does '- do in a cell?
You might try using =NA() to return a #N/A value. The ' apostrophe
character at the beginning of the text in a cell tells Excel to treat the following content as literal text, not to be translated. For example, if you enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or 1-Feb-1934 depending locale settings). If you precede this entry with an apostrophe, Excel treats it as literal text and does not convert it to a date. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "sc16" wrote in message ... i'm trying to indicate that there is no relation cost between an origin and a destination however 0 would not indicate this as zero would indicate that the cost = $0.. what can i put into a cell to let it know that no relation exists when i want to use the solver tool? also, what exactly does '- mean in a cell? |
what does '- do in a cell?
Hey Chip,
Unfortunately that doesn't work either! =( but thanks for the thought.. appreciate it =) "Chip Pearson" wrote: You might try using =NA() to return a #N/A value. The ' apostrophe character at the beginning of the text in a cell tells Excel to treat the following content as literal text, not to be translated. For example, if you enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or 1-Feb-1934 depending locale settings). If you precede this entry with an apostrophe, Excel treats it as literal text and does not convert it to a date. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "sc16" wrote in message ... i'm trying to indicate that there is no relation cost between an origin and a destination however 0 would not indicate this as zero would indicate that the cost = $0.. what can i put into a cell to let it know that no relation exists when i want to use the solver tool? also, what exactly does '- mean in a cell? |
what does '- do in a cell?
I think Chip missed the - in your question. However, what he said still
holds true for that condition. The ['-] means don't treat this as a numerical operator, but as a short dash. "sc16" wrote: Hey Chip, Unfortunately that doesn't work either! =( but thanks for the thought.. appreciate it =) "Chip Pearson" wrote: You might try using =NA() to return a #N/A value. The ' apostrophe character at the beginning of the text in a cell tells Excel to treat the following content as literal text, not to be translated. For example, if you enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or 1-Feb-1934 depending locale settings). If you precede this entry with an apostrophe, Excel treats it as literal text and does not convert it to a date. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "sc16" wrote in message ... i'm trying to indicate that there is no relation cost between an origin and a destination however 0 would not indicate this as zero would indicate that the cost = $0.. what can i put into a cell to let it know that no relation exists when i want to use the solver tool? also, what exactly does '- mean in a cell? |
All times are GMT +1. The time now is 12:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com