#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
Quote:
go to "format/text" "enter" |
#3
|
|||
|
|||
Hi,
Thanks for the reply, but there is some confusion : Quote:
Is it located in the context menu when we right click a cell ? |
#4
|
||||
|
||||
Right click on the cell, select "Format Cells", then select "Text" under the tab "Number".
|
#5
|
|||
|
|||
Hello Kevin,
Thank you for the 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 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 |