Hello everyone. I am new to Excel Forum, so my apologies in advanced for any oversights. I am in desperate need of help with an excel issue, and I'm hoping someone can help; I will do my best to describe the issue. I am attempting to customize a cell in excel to have an alpha suffix after a numeric value has been entered. So far I have been successful in doing so by using the customized cell format description of: $##.00 _ "/ EA". This code results as such Example: if you input 1.1, the cell display is as follows: $1.10 / EA. by using this code, the "EA" portion of the output is fixed, however I am now having another new issue. The unit description, in this case being "EA", is subject to change and will be dependent on another cell, so what I am looking for is the code of how to have my alpha output unit value dependant on another cell. Can anyone please help? Thank you in advanced!!!
You can't type in a cell and have "Varying" suffixes appear automatically in the same cell you typed in, you can only apply one number formatting scheme, and number formats do not refer to other cells.
However you CAN accomplish this in an adjacent cell. If you type a value in A1 and qty type (EA, Cs, BTL, Oz) in B1, then in C1 you could construct this output:
="$" & TEXT(A1, "0.00") & "/ " & B1
If you want to change the numberformatting applied to cell based on some other cell you type in, that would require VBA programming to automate.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Not exactly what I was looking for, but Thanks for the reponse Jerry..! You extremely knowledgable in excel! If you have time, I can forward you the spreadsheet, which might help explain what I am trying to do a little better if you'd like?
I know it's not what you're looking for, I'm suggesting something that IS available to you in formula/cell only format.
Anything like your original question will require VBA. You can post your file and fuller information here if that's the path you want to take, not everyone is up for maintaining a workbook full of macros.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks