How to stop correcting zeroes in cells ?

		Microsoft Office Forums > Microsoft Excel > Excel
How to stop correcting zeroes in cells ?

FAQ

Thread Tools

Display Modes

09-11-2008, 10:40 AM

ram1000

Novice

Join Date: Sep 2008

Posts: 3

Quote:

Originally Posted by kevin_ms

Hello,
I want to stop excel from correcting zeroes.

For example, when I type 0456 in a cell, then excel corrects it to 456.
How to stop this from happening ?

highlight the cell or cells
go to "format/text" "enter"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot stop the date being printed in the footer	Ubtree	Outlook	0	10-13-2007 11:49 AM
Stop individual emails from being archived.	saltydog85	Outlook	0	07-06-2007 02:13 PM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM
Nested if formulat to merge cells	cristi22	Excel	0	10-23-2006 08:28 AM
Problem - how do I stop duplicate emails	avarchcm	Outlook	1	09-11-2006 11:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 AM.