Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
Whenever I copy and paste the following column into Excel
64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
Excel is a real pita when doing this!
Pre-format the destination cells as TEXT then use Paste SpecialTextOK -- Biff Microsoft Excel MVP "GregNga" wrote in message ... Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
GregNga
Excell will only handle 15 numbers as numbers, anything above 15 needs to be handled as text. Which means you can not use them in computations. Preceed the entry with a single quote " ' ", or formate the cell as text before you make an entry. Mike Rogers "GregNga" wrote: Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
Preformatting as test yields
6.40822E+16 1.75018E+16 4.0311E+16 7.47057E+15 I am not using them in calculation, only display "T. Valko" wrote: Excel is a real pita when doing this! Pre-format the destination cells as TEXT then use Paste SpecialTextOK -- Biff Microsoft Excel MVP "GregNga" wrote in message ... Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
Sorry, I didn't see the "PASTE SPECIAL" part, let me try it
"T. Valko" wrote: Excel is a real pita when doing this! Pre-format the destination cells as TEXT then use Paste SpecialTextOK -- Biff Microsoft Excel MVP "GregNga" wrote in message ... Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
yes, that works.........many thanks
"GregNga" wrote: Sorry, I didn't see the "PASTE SPECIAL" part, let me try it "T. Valko" wrote: Excel is a real pita when doing this! Pre-format the destination cells as TEXT then use Paste SpecialTextOK -- Biff Microsoft Excel MVP "GregNga" wrote in message ... Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding issue in Excel 2000
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "GregNga" wrote in message ... yes, that works.........many thanks "GregNga" wrote: Sorry, I didn't see the "PASTE SPECIAL" part, let me try it "T. Valko" wrote: Excel is a real pita when doing this! Pre-format the destination cells as TEXT then use Paste SpecialTextOK -- Biff Microsoft Excel MVP "GregNga" wrote in message ... Whenever I copy and paste the following column into Excel 64082153021072309 17501818699072309 40310967596072309 07470568444072309 it is displayed as 64082153021072300 17501818699072300 40310967596072300 7470568444072309 How do I get Excel to display this without rounding up and trucating the leading zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Font Format Issue | Excel Discussion (Misc queries) | |||
Rounding issue | Excel Discussion (Misc queries) | |||
Excel Rounding Issue | Excel Discussion (Misc queries) | |||
Excel 2000 Issue | Setting up and Configuration of Excel | |||
Another rounding issue | Excel Worksheet Functions |