Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I type in full figure
I would like to enter full figure as show 0000345 in the chart, but it appear
to show as 345 and not 0000345 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I type in full figure
You can format the cell as "Text" and it will retain exactly what you
type into it. (Right click on the cell, "Format Cells", "Number" tab, select 'Text'). Shubha Kawa wrote: I would like to enter full figure as show 0000345 in the chart, but it appear to show as 345 and not 0000345 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs | Excel Worksheet Functions | |||
Can I automaticly figure "cost" and sale price in Excel? | Excel Worksheet Functions | |||
Splitting a Target Figure | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Custom Type Charts Problem | Excel Worksheet Functions |