Global fix for scientific number format?
Does anyone know if there is a way to globally change the
format of a number that displays as a scientific number? For example, I have a column of numbers that are being displayed like "0348489+E", etc... If I change the format to text, it still doesn't help. I have tried the apostrophe before the number and it does seem to change it to the number that I need it to be, however, I have about 10,000 numbers that I need to put the apostrophe in front of and can't possibly do it to each one individually. Is there any way to do this to all of the numbers at once? Thanks for the help. |
Highlight all the numbers, then use FormatCells from the menu. Select the
Number tab. In the left column, choose Custom, and in the right column select the "0" Click on OK "Carol" wrote in message ... Does anyone know if there is a way to globally change the format of a number that displays as a scientific number? For example, I have a column of numbers that are being displayed like "0348489+E", etc... If I change the format to text, it still doesn't help. I have tried the apostrophe before the number and it does seem to change it to the number that I need it to be, however, I have about 10,000 numbers that I need to put the apostrophe in front of and can't possibly do it to each one individually. Is there any way to do this to all of the numbers at once? Thanks for the help. |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com