Fixed display custom format

[Jhon Mustofa]

dear all,

simple question, i have using custom format and i want to fixed it as display (real display)..

it's possible to fixed value/data,

result after custom format
012/2014----------------------------012/2014 (real display/expected result)
005/2014----------------------------005/2014 (real display/expected result)
895/2014----------------------------895/2014 (real display/expected result)

thanks!!

john.m

[newdoverman]

If I understand you correctly you want a Custom Number format of ???/2014 if you want to be able to enter all the digits including the 2014.

If you only want to enter the first 3 digits and have the output that you describe this will do it in Custom Number Format ???"/2014"

To format the cells where this formatting is required, select the cells then right click in them and choose Format Cells. Click on the Number tab, Number, Custom and enter the format.

Ctrl + 1 is the keyboard shortcut to get to the formatting.

[Jhon Mustofa]

thanks newdoverman, but not like this...

i just want to fixed real display after using custom format, some like "what you type if what you get" exactly same..

any ideas, new???

[Jhon Mustofa]

for detail...please see my sample file...

[newdoverman]

Just centre column C and you will have real fractions that you can calculate with and they will appear to be like the values in column D that I take are text values.

[Jhon Mustofa]

but...if i press F2, the number show is not actually same with number/value in column D (desired result)...

it's possible to make it actually same (before/after press F2)??

[martindwilson]

you cant custom format just changes the appearance not the underlying value
you could get it be referencing a cell
=TEXT(a1,"000")&"/2014" copy paste back as value

[Jhon Mustofa]

martin, thanks you, that's i want.....

it's really working well...