ExcelBanter - custom cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - custom cell (https://www.excelbanter.com/excel-discussion-misc-queries/194239-custom-cell.html)

Renee'

custom cell

i want to be able to just put in 2 numbers instead of 6 each time. How can i
custom a cell to be able to put 00-00000 ?

i tried to use the 000"-00-000" put it would not work for the above. any
suggestions?

thanks

Pimamedic

custom cell

DId you mean 00-0000 or 00.0000??

"Renee'" wrote:

i want to be able to just put in 2 numbers instead of 6 each time. How can i
custom a cell to be able to put 00-00000 ?

i tried to use the 000"-00-000" put it would not work for the above. any
suggestions?

thanks

Don

custom cell

try doing format/cell then in the category choose Custom and type in the
following

00-00000

when you enter 1234567 , it will show as 12-34567

"Renee'" wrote:

i want to be able to just put in 2 numbers instead of 6 each time. How can i
custom a cell to be able to put 00-00000 ?

i tried to use the 000"-00-000" put it would not work for the above. any
suggestions?

thanks

All times are GMT +1. The time now is 11:46 PM.