Thread: Number format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SpreadsheetBrian SpreadsheetBrian is offline
external usenet poster
 
Posts: 12
Default 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