Thread: [Solved] How to stop correcting zeroes in cells ?
View Single Post
 
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