View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I type in full figure

If you don't need the cell to be numeric, format it as text first (Format
Cells Number Text, or type an apostrophe first: '0000345.

If you need the cell to retain its numerical value, assign a custom number
format with as many zeros as you need digits: Format Cells Number
Custom, and enter 0000000.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Shubha Kawa" <Shubha wrote in message
...
I would like to enter full figure as show 0000345 in the chart, but it
appear
to show as 345 and not 0000345