Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Prasoon" wrote:
On assigning numeric value starting with zero , the value is shown without zero. I want to show zero in front of the assign value only in those values where zero is given. If you want to use the value as a number, you could format the individual cell with a custom format with the correct number of digits of the form 000000 (for a 6-digit number). Of course, that's a manual operation. However, if the value is never uses a number (e.g. never used in an arithmetic expression), it would be better to prefix the value with an apostrophe or, if you have the benefit of forethought, format the cell as Text before entering the value. If you are importing data, you can set the column to be imported as Text instead of General. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to enter zip starting with 0 (zero) | New Users to Excel | |||
Enter doesnt return to the cell below the starting point anymore | Excel Discussion (Misc queries) | |||
How do you enter zip codes starting with 0 for a mail merge | Setting up and Configuration of Excel | |||
how do I enter a zipcode starting with a 0 | Excel Discussion (Misc queries) | |||
how do i enter numbers starting with zero in excel | Excel Discussion (Misc queries) |