| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Right Justifing in Excel
I am wondering how to write a formula to right justify my data within a
column. I cannot use the formatting on the menu or toolbar because when I save my document to a .txt file, it doesn't preserve the formatting. I am looking to right justify data in a column that contains numbers (i.e. 10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my file as a fixed length record text file. Thanks! -- J Harris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Right Justifing in Excel
I'm not sure I understand the question. When XL data is saved to a .txt
file, only the values, not the formulas that calculate the values, are stored. Dave -- Brevity is the soul of wit. "J Harris" wrote: I am wondering how to write a formula to right justify my data within a column. I cannot use the formatting on the menu or toolbar because when I save my document to a .txt file, it doesn't preserve the formatting. I am looking to right justify data in a column that contains numbers (i.e. 10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my file as a fixed length record text file. Thanks! -- J Harris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Right Justifing in Excel
Let's say your value is in cell A1 and you need it to take up 15 characters
in total =rept(" ", 15-len(A1))&A1 "J Harris" wrote: I am wondering how to write a formula to right justify my data within a column. I cannot use the formatting on the menu or toolbar because when I save my document to a .txt file, it doesn't preserve the formatting. I am looking to right justify data in a column that contains numbers (i.e. 10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my file as a fixed length record text file. Thanks! -- J Harris |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Right Justifing in Excel
That is exactly what I was looking for. Thanks for the help!
-- J Harris "Duke Carey" wrote: Let's say your value is in cell A1 and you need it to take up 15 characters in total =rept(" ", 15-len(A1))&A1 "J Harris" wrote: I am wondering how to write a formula to right justify my data within a column. I cannot use the formatting on the menu or toolbar because when I save my document to a .txt file, it doesn't preserve the formatting. I am looking to right justify data in a column that contains numbers (i.e. 10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my file as a fixed length record text file. Thanks! -- J Harris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hybrid Mode
