Number format

[Guest]

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

 

[Peo Sjoblom]

Not possible using formatting

 

[SpreadsheetBrian]

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

 

[Guest]

Thanks for your help.

Not possible using formatting

 

[Guest]

Thanks for your help. The problem is the text is variable, so is not possible.