Then where did I submit it? If it is this difficult to submit, then why?
My specific examples were provided in what I submitted. Where are they? Again. Why is it so difficult to submit?
Specific examples.
- Number extraction
Cell A1: 06/04 Purchase $265.69 Cash Back $40.00
[total amount of transaction is $$305.69]
Cell B1 formula: +RIGHT(A1,6) … RESULT: $40.00, even when formula result cell formatted for… $ 40.00 … [or negative of $ (40.00)… number format…
[>0]" $"* #,##0.00" “;[<0]” $"* (#,##0.00);" $"* -#" “;” “@” "
This format works for me, but not when using the result value from the formula in cell B1.
With the formula result of $40.00 (value not formula), other formulas are not always able to recognize this number. Other numbers using the format above do come out, when I type a number, as $ 40.00 …
With the value which comes from the formula result and using the same format, I get $40.00 and difficulty recognizing this as a number. Why?
[NOTE: have tried both (A1,6) or (A1,5) and get same result with each]
- Date extraction
Cell A1: 06/04 Purchase $265.69 Cash Back $40.00
[total amount of transaction is $$305.69]
The date in A1 is without the year. It is current year. In Excel, have been able to extract full date, 06/04/2022. In LibreOffice Calc, I began with what I once used in Excel. It did not work. Have spent hours and hours trying to find a formula in Calc which will work. Why?
NOTE: I used the word, “stinks,” not the “" word. The word “stink” is commonly used, so I don’t need to be told NOT to use it, unless we are all of purity. I try to avoid the "” word as much as possible. As I explained in my message, I used the word, “stink,” because of the hours and hours I have spent trying to figure this thing out and am still coming up empty-handed with all the solutions tried, never receiving a reply back when I inquired, and becoming irritated at what ever has happened to make these further problems happen to me. Don’t know what is happening that someone would want to put a word I used before helping me solve my problem. My initial requests were being kind and with inquiry. Please reply to me and be kind to me. You need to attempt to understand my situation, all the way around.
Douglas Cornwell
bibsinger(at)gmail-com
Edited by @Ratslinger - Common is not an excuse. This site is used by peoples of various ages and backgrounds. Please refrain from inappropriate language. Thank You.
