Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting length of data in Excel
Is there a way to format imported data to always have 5 digits or
characters... no matter where the decimal point appears. Example: 12.345 1.2345 123.45 1234.5 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting length of data in Excel
On Tue, 4 May 2010 16:31:01 -0700, LaBonita
wrote: Is there a way to format imported data to always have 5 digits or characters... no matter where the decimal point appears. Example: 12.345 1.2345 123.45 1234.5 Thanks What do you want to do about trailing zero's? In other words, what if the imported number is 12? Is 12 sufficient for display, or do you need 12.000? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the Length of Time a File Can Stay Open | Excel Discussion (Misc queries) | |||
setting chart length & width in centimeters | Charts and Charting in Excel | |||
setting a cell length limit | Excel Discussion (Misc queries) | |||
Setting page length to 60 lines? (How do?) | Excel Discussion (Misc queries) | |||
Setting page length in Excel 2003 | Excel Worksheet Functions |