Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
zero to the left of a number
To any expert on the field of excel 2003:
I have a range of cells with number values however some number start with a zero . HOW DO I MAKE THAT ZERO COUNT AS A NUMBER WITHOUT USING AN APOSTROPHE IN FRONT OF IT, SUCH THAT WHEN I ENTER THE NUMBER IN THE CELL THE ZERO WILL NOT DISAPEAR WHEN I HIT THE ENTER KEY. I AM AWARE THAT I CAN USE AN APOSTROPHE IN FRONT OF THE ZERO, HOWEVER I CANNOT USE A FUNCTION WITH THE APOSTROPHE IN FRONT OF THE RANGE THAT HAS A ZERO BECAUSE THIS CELL WOULD BE FORMATTED AND IT WILL NOT WORK. EXAMPLE: I TYPE IN A2: 0436 WHEN I HIT ENTER IT BECOMES 436, HOWEVER i NEED THAT ZERO INFRONT OF THE NUMBER FOR id PURPOSE. tHANK YOU JOSEPH ROBERT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test left character is a number? | Excel Discussion (Misc queries) | |||
How do I change my number on chart to left | Excel Discussion (Misc queries) | |||
How do i page left or right a set number of columns, rather than | New Users to Excel | |||
How to extract left-most number from a string | Excel Worksheet Functions | |||
Display zeros to the left of a number | Excel Programming |