Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2008, 03:56 AM
kevin_ms kevin_ms is offline
Novice
How to stop correcting zeroes in cells ?
 
Join Date: Sep 2008
Posts: 3
kevin_ms is on a distinguished road
Default How to stop correcting zeroes in cells ?


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 ?
Reply With Quote
  #2  
Old 09-11-2008, 10:40 AM
ram1000 ram1000 is offline
Novice
 
Join Date: Sep 2008
Posts: 3
ram1000 is on a distinguished road
Default

Quote:
Originally Posted by kevin_ms View Post
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"
Reply With Quote
  #3  
Old 09-13-2008, 12:35 AM
kevin_ms kevin_ms is offline
Novice
How to stop correcting zeroes in cells ?
 
Join Date: Sep 2008
Posts: 3
kevin_ms is on a distinguished road
Default

Hi,
Thanks for the reply, but there is some confusion :

Quote:
highlight the cell or cells
go to "format/text" "enter"
Where can I find this ? "Format/text" .... enter"

Is it located in the context menu when we right click a cell ?
Reply With Quote
  #4  
Old 09-13-2008, 06:23 AM
Matrix's Avatar
Matrix Matrix is offline How to stop correcting zeroes in cells ? Windows 10 How to stop correcting zeroes in cells ? Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Right click on the cell, select "Format Cells", then select "Text" under the tab "Number".
Reply With Quote
  #5  
Old 09-14-2008, 10:08 PM
kevin_ms kevin_ms is offline
Novice
How to stop correcting zeroes in cells ?
 
Join Date: Sep 2008
Posts: 3
kevin_ms is on a distinguished road
Default

Hello Kevin,
Thank you for the reply.
Reply With Quote
Reply

Thread Tools
Display Modes


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 stop correcting zeroes in cells ? 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
How to stop correcting zeroes in cells ? 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 12:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft