| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
I need to introduce data that may be, for example: dh-34-22 or 44-ff-44 or
44-33-rr. I want to create a new number format to be more easy. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
Not possible using formatting
-- Regards, Peo Sjoblom "agpaco" wrote in message ... I need to introduce data that may be, for example: dh-34-22 or 44-ff-44 or 44-33-rr. I want to create a new number format to be more easy. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
On Jun 27, 4:12 pm, agpaco wrote:
I need to introduce data that may be, for example: dh-34-22 or 44-ff-44 or 44-33-rr. I want to create a new number format to be more easy. Thanks Your requirements are a little vague. You can format the number 4433 to look like 44-33-rr with the format 00-00"-rr", which will apply to any number, so.. 1000 looks like 10-00-rr 1234 looks like 12-34-rr You an create a second format of "dh-"00-00 to format 9876 into dh-98-76 Even 5678 can be formatted with 00"-ff-"00 to look like 56-ff-78. This only works if you have a fixed and predictable set of formats. That's up to you to determine. Brian Herbert Withun |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
Thanks for your help.
"Peo Sjoblom" wrote: Not possible using formatting -- Regards, Peo Sjoblom "agpaco" wrote in message ... I need to introduce data that may be, for example: dh-34-22 or 44-ff-44 or 44-33-rr. I want to create a new number format to be more easy. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
Thanks for your help. The problem is the text is variable, so is not possible.
"SpreadsheetBrian" wrote: On Jun 27, 4:12 pm, agpaco wrote: I need to introduce data that may be, for example: dh-34-22 or 44-ff-44 or 44-33-rr. I want to create a new number format to be more easy. Thanks Your requirements are a little vague. You can format the number 4433 to look like 44-33-rr with the format 00-00"-rr", which will apply to any number, so.. 1000 looks like 10-00-rr 1234 looks like 12-34-rr You an create a second format of "dh-"00-00 to format 9876 into dh-98-76 Even 5678 can be formatted with 00"-ff-"00 to look like 56-ff-78. This only works if you have a fixed and predictable set of formats. That's up to you to determine. Brian Herbert Withun |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Linear Mode
