Donate SIGN UP
Home > Technology > Computers > EXCEL zero

EXCEL zero

Avatar Image
748rhydhir | 15:46 Mon 20th Oct 2008 | Computers
3 Answers
how do you write a number in rows or columns with the initial number 0.eg 01234.
It will write the 0 but when you move on the 0 goes & you are left with 1234.

many thanks
regards,
john
prev Yod'm 3D
  
next Frozen out
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by 748rhydhir. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image ChuckFickens
click the cell you want to change click on the format menu and select celll and then scroll down the list and change it to a text cell.

Then any number will keep the leading 0
16:03 Mon 20th Oct 2008
Avatar Image kempie
Alternatively type a ' (single quote) before the number

e.g '012345
16:20 Mon 20th Oct 2008
Avatar Image 748rhydhir
Question Author
many thanks for swift replies.
chuckfickens solution worked a treat.
17:19 Mon 20th Oct 2008

1 to 3 of 3rss feed

Do you know the answer?

EXCEL zero

Answer Question >>