View Single Post
  #4   Report Post  
breeze
 
Posts: n/a
Default

Thanks a lot.

breeze
=========
"Arvi Laanemets" wrote in message
...
Hi

a) format the cell as Custom "00000"
b) format the cell as Text
c) preceede the number with apostrophe, i.e. enter '04980

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"breeze" wrote in message
...
The real number I enter into cells need be "049800".
I got "4980". How to adjust that display zero in front and behind number?