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

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

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

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

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