Is there a way to have a format on a cell that would allow for:
3 Characters - 6 numbers?
What I need is something like NEW-001266. But the numbers and letters will always change. It may be PEO-001610, or HUT-00200, etc.
I can get it if the characters don't changes.
Thanks!
I've got several spreadsheets that I must re-do quarterly. The last column is a sum of hours and minutes from several other spreadsheets. That's another issue entirely. Right now the individual types in 8hr15m. Can someone help me with a custom format so that when she types it in, the text hr (space) m is already there? I'd like her to be able to just type in the numbers on a keypad. Thanks
First time poster. I'm no Excel expert, but I've never needed help with something that I couldn't figure out on my own.
Ok, I have an Excel file that I'm trying to turn to a .txt. The tricky part is that I need very specific format that starts off with four spaces then specific numbers of characters through the rest. I tried to use & to join the cells. ie...
" "&A1&" "&B1&" "&C1
The problem is B1 is custom formatted as 0000000000 but the number in the cell may only be 5 digits. So when & is used it loses the format and just gives the value of the cell without the formatting. I need that formatting.
If there is a way to do this I would be very interested in knowing it. Thanks a lot.
Matt
i have a long colum of custom formated dates i need to change them into text
in order to prosses them -the custom format is dd/mm/yyyy h:mm the cell reads
01/09/2005 9:30 the number that shows up is 38596.39583 when i try to convert
the format to standard text. is there a function that will do this for me?
In 2003 SP2, I am looking to take my existing custom format, ###-###-###, and
be able to add occasional random text (A, B, C, etc...), but still keep just
the number if no text is given. Any ideas?
Is it possible to use a custom number format to display in a time format with timezone?
Example:
Code:
Cell contains | Want to display as
1500ct | 15:00 ct
1500pt | 15:00 pt
0500pt | 05:00 pt
So it should always display 1st character, 2nd character, ":", 3rd character, 4th character, then whatever text is leftover.
It doesn't appear that custom number format is able to control character-by-character display like this.
I am trying to differentiate data points that are in cases and those that are in gallons in a spreadsheet that is over 20K rows. The data I have looks like this: 1,200 CS.
I want to put the 1,200 in one column and "CS" in another. The problem is, the cell has a custom format put on it (#,##0.000" CS";-#,##0.000" CS";#,##0.000;@ the ones formatted as Gallons have a custom format as follows: #,##0.000" GAL";-#,##0.000" GAL";#,##0.000;@) so when you click in the cell, the real value is only 1,200 and I can't easily do a text to columns to see what is in cases and what is in gallons.
I'm working in Excel 2007
Please help, this is driving me crazy!
Thanks,
Jamie
Hello all, I have a spreadsheet that I have calculated some numbers and have the cell formatted to # ??/??. Using the MROUND function on the cell I take a number like this 0.4375 and convert it to a fraction like using =MROUND (A1, 1/16). This gives me 7/16 instead of 0.4375. I use this to get my "measurements" to look like the fractions of an inch on a tape measure.
My question is: How can I concatenate this number together with another one and have it display properly still (e.g. take cell A1 which is 7/16 and cell B1 which is 1/2 and combine them with other text to get: 7/16" to 1/2").
Thank you for your help with this.
Hello, I am using Excel 2003.
When I use a Custom Number Format in the Form * @_) the text will right aligned with a little space from the right cell border.
However, this does not work if the cell is assigned the property Wrap Text.
Is there a way to make both things work or are those properties just not usable at the same time?
regards
Hi.
Is it possible to custom number format a cell based on text?
For example, I have a column with a bunch of people names.
What I want is based on the name written, the cell will only allow a 2 digits number or a 4 digit number.
I tried something like =TEXT(A1;"VLOOKUP(C1;$D$1:$E$10;2)"), but I had no luck.
I thought using the VLOOKUP so I could use the format "0.00" and "0.0000" for each person name, so the text function would recognize the format, but apparently I was wrong.
Any help?
Regards.
