Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter signs w/o Excel assuming it's a formula
Once more I've encountered a problem apparently caused by programmers not
paying attention to the users. I have a spreadsheet that MUST show the signs (+/-) of a number. For one series, the unit MUST also show. So, positive numbers MUST be shown as +##.### and negatives as -##.###. When units are shown, the format MUST be +##.### lbs. and -##.### lbs. What's especially aggravating is when I enter -##.### lbs., Excel assumes it's a formula, not text. (This coding is only slightly less aggravating than Excel assuming entering 234 + 456 is text, not a formual. At least Quattro Pro got that right.) Any suggestions? -- I know enuff to be dangerous. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter signs w/o Excel assuming it's a formula
If you need a + or - sign to appear in a text string, put an apostrophe to
the left of the + or - sign. Alternatively, format the cells as text prior to entering the text string. Dave -- Brevity is the soul of wit. "RealGomer" wrote: Once more I've encountered a problem apparently caused by programmers not paying attention to the users. I have a spreadsheet that MUST show the signs (+/-) of a number. For one series, the unit MUST also show. So, positive numbers MUST be shown as +##.### and negatives as -##.###. When units are shown, the format MUST be +##.### lbs. and -##.### lbs. What's especially aggravating is when I enter -##.### lbs., Excel assumes it's a formula, not text. (This coding is only slightly less aggravating than Excel assuming entering 234 + 456 is text, not a formual. At least Quattro Pro got that right.) Any suggestions? -- I know enuff to be dangerous. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter signs w/o Excel assuming it's a formula
Just input the numbers, and let the Formatting do... the Formatting.
Enter -12.345. FormatCellsNumber tab, Custom Type: +00.000 "lbs";-00.000 "lbs" Just an example, you may require # instead of 0, but hopefully you got the idea. -- Kind regards, Niek Otten Microsoft MVP - Excel "RealGomer" wrote in message ... | Once more I've encountered a problem apparently caused by programmers not | paying attention to the users. I have a spreadsheet that MUST show the signs | (+/-) of a number. For one series, the unit MUST also show. So, positive | numbers MUST be shown as +##.### and negatives as -##.###. When units are | shown, the format MUST be +##.### lbs. and -##.### lbs. What's especially | aggravating is when I enter -##.### lbs., Excel assumes it's a formula, not | text. (This coding is only slightly less aggravating than Excel assuming | entering 234 + 456 is text, not a formual. At least Quattro Pro got that | right.) | Any suggestions? | -- | I know enuff to be dangerous. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter signs w/o Excel assuming it's a formula
Niek, I never thought about using a custom format. I have to use them enough
for all the ID and account numbers we have to record. Thanks! -- I know enuff to be dangerous. "Niek Otten" wrote: Just input the numbers, and let the Formatting do... the Formatting. Enter -12.345. FormatCellsNumber tab, Custom Type: +00.000 "lbs";-00.000 "lbs" Just an example, you may require # instead of 0, but hopefully you got the idea. -- Kind regards, Niek Otten Microsoft MVP - Excel "RealGomer" wrote in message ... | Once more I've encountered a problem apparently caused by programmers not | paying attention to the users. I have a spreadsheet that MUST show the signs | (+/-) of a number. For one series, the unit MUST also show. So, positive | numbers MUST be shown as +##.### and negatives as -##.###. When units are | shown, the format MUST be +##.### lbs. and -##.### lbs. What's especially | aggravating is when I enter -##.### lbs., Excel assumes it's a formula, not | text. (This coding is only slightly less aggravating than Excel assuming | entering 234 + 456 is text, not a formual. At least Quattro Pro got that | right.) | Any suggestions? | -- | I know enuff to be dangerous. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
I am entering date in Excel when I hit enter a formula appears? | New Users to Excel | |||
How do I enter formula for < or numbers. | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions |