Value

[minrush]

When I type 0012345 in a cell

the cell shows only 12345

when I print it also shows 12345

I want to be able to see 0012345 and print 0012345

Same problem.. when I input 12,000 it shows as 12,000 but when i utilize in a database and print.. it only shows as 12000.. I want to print with the comma..

Please help

 

[DonkeyOte]

Hi, you will want to format your cells as Text rather than General.

HTH.

 

[Stormseed]

Hi

Select the cell where you want to display 0012345. Then click on Excel Menubar --> Format --> Cells --> Number tab --> Select "Custom" in Category. On the right side under the option "Type:", enter 0000000 --> finally click on OK.

I have not tested this but a "Print Preview" shows me that if you try to print the number after applying the above format, it would show "0012345" on the page.

 

[DonkeyOte]

Stormseed, unfortunately this would not hold true for 12,000 as this would become 00120000.

 

[Stormseed]

Hi Luke

There is no need to apply the custom format to "12000" (without quotes). Just a click on 'comma style' option on the toolbar would format it as a comma seperated value and it would be displayed as "12,000" (without quotes). Do a print preview on this too and it will print "12,000" (without quotes).

This is working for me perfectly on Excel 2002.

 

[DonkeyOte]

Yes but you're then formatting cells individually, formatting column/range as Text would cater for all cells.

 

[Stormseed]

Luke, I ain't saying my post as a solution is better or more useful than yours. I would leave it to the OP to use whichever solution with which he / she is comfortable

Our job was to provide help to the OP and we did that fair enough