| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding off numbers gives an E in pivot table
Hi,
In my Worksheet Column A I have figure e.x 325,255, 250,250 etc.I divided them by 1000 in a seperate column and posted them back to column A and formatted it to 0 decimal places so that the figures were like 325.26,250.25 etc.When I put them in a Pivot there was still a value like 2.3333E-12. Could someone let me know a better way. Thanks -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table formatting numbers | Excel Worksheet Functions | |||
| Negative Numbers in a Pivot Table | Excel Worksheet Functions | |||
| Displaying Text, not numbers, in Pivot Table | New Users to Excel | |||
| Making Text into Numbers, for Pivot Table Cubes | Excel Worksheet Functions | |||
| Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
